by Natalia Sharashova, updated on
In this article, you will learn about two ways of replacing all formulas with their results in a spreadsheet.
Whether you need to transfer data between sheets or even spreadsheets, keep formulas from recalculating (for example, the RAND function), or simply speed up your spreadsheet performance, having the calculated values instead of their formulas will help.
Today I offer you two options to make this possible: the standard and the fastest.
Let's imagine you have a list of web pages and you use a special function to pull the domain names from those long links:
Now you need to switch all formulas to results instead. Here's what you can do:
Tip. Ctrl+Shift+V is the Google Sheets shortcut for Paste values only (right-click a cell > Paste special > Paste values only).
If you'd rather avoid stumbling over incorrect buttons, we've got you covered. Our Power Tools – a collection of 30+ add-ons for Google Sheets – contains a perfect assistant.
Tip. To run the Formulas tool right away, go to Add-ons > Power Tools > Formulas.
Tip. You can repeat this action even quicker from the main Power Tools window.
Once you convert formulas to values, this action will appear in the Recent tools tab at the bottom of the main window. Click there to run the tool again or star it to add it to your Favorite tools for future use:
I highly recommend you to try other add-ons from Power Tools: 5 minutes saved here and 15 there may become a game changer in your work efficiency.
Table of contents