Thankfully, it’s possible to choose whether Google Sheets copies and pastes a formula or just pastes the result of that formula as a value. Doing so is quick and easy, once you know how. If you’re unsure how to copy a value not a formula in Google Sheets, follow the steps below.
Why You Might Want to Copy a Value and Not a Formula in Google Sheets
When you’re copying a cell that contains a formula, Google Sheets will default to pasting the formula itself rather than the result. This can lead to issues, as moving the formula to a different location may mess up the cell references. For example, suppose you have a formula that creates a sum of a list of values. The cell itself shows the result of the sum, but if you click on the cell, you can still see the formula. When you copy this cell and paste it into another location, the formula gets copied. Since the cell is now in a different location, the formula cannot locate the same cells to sum up, leading to an error. It is possible, however, to copy and paste the result of the formula, rather than the formula itself. This is what copying the value achieves.
How to Copy a Value in Google Sheets Using Paste Special
If you use the standard paste function when you copy a cell containing a formula, the new cell will contain the formula but not the value. In order to copy and paste the value, you can use the Paste Special function to choose exactly what gets pasted into your cell. To copy a value using Paste Special in Google Sheets:
How to Copy a Value Using Keyboard Shortcuts
You can also achieve the same result by making use of keyboard shortcuts. The standard method of using Ctrl + V (or Cmd + V on Mac) will not work, however. This will paste the formula rather than the value, so you’ll need to use a different keyboard shortcut. To copy and paste a value using keyboard shortcuts in Google Sheets:
How to Copy a Value Using a Formula in Google Sheets
There is another way that you can make the value from one cell appear in another. Ironically, this method involves inserting a formula into the cell where you want the value to appear. The beauty of this method is that if the value in the original cell changes, your new cell will also update to match. To copy a value using a formula in Google Sheets:
Making Changes to Google Sheets Spreadsheets
Figuring out how to copy a value not a formula in Google Sheets may not be completely obvious at first, but once you know how, it’s simple to do. There are plenty of more features of Google Sheets that are equally easy to use once you’ve learned how. If you want to see all of the formulas in your spreadsheet instead of their values, you can get Google Sheets to show formulas by enabling formula view. If you have key data in another sheet of your document, you can query another sheet in Google Sheets. You can also take control of the format of your cells by creating custom number formats in Google Sheets. Comment Name * Email *
Δ Save my name and email and send me emails as new comments are made to this post.
