Google Sheets – How to Copy & Paste Hyperlink Formulas as Values and Keep Links

To copy and paste Google Sheets hyperlink formulas as values while preserving the linked text, copy the cells and paste them into Google Docs as a table. Then, copy the table out of Google Docs and back into Google Sheets.

This workaround allows you to “paste values only” without losing the hyperlinks created by your Google Sheets formulas.