How to Copy Values and Not Formulas in Google Sheets

In this tutorial, you will learn how to copy values and not formulas in a Google Sheets spreadsheet.

How to Copy Values and Not Formulas in Google Sheets

When a user copies and pastes data in Google Sheets, it will copy both the values and the formulas by default. This may be helpful if you want to quickly duplicate a row of data, including the formulas.

However, there may be times when you only want to copy the values, and not the formulas. For example, you may want to paste the data into another application that does not support Google Sheets formulas.

In this guide, we will show you how to copy values and not formulas in Google Sheets. We will explain how to use the Paste Special function as well as an array formula to copy values from a range without copying the formula.

How to Paste as Values Only in Google Sheets

Here’s how to paste as values only in Google Sheets.

Step 1

Select the range you want to copy as values.

In this example, we want to copy and paste the tax field which is computed with a simple formula.

Step 2

Use the keyboard shortcut Ctrl + C to copy the selected range.

Step 3

Next, select a new cell in another column. Right-click on the cell and select Paste special > Values only.

Step 4

You should now have the same values in the new range. However, the new range is composed of cells with numerical values only.

Step 5

We can also use the array syntax to create a copy of the values.

First, write down the range you want to copy as values. Add opening and closing curly brackets to indicate we want to return an array.

Step 6

After evaluating the formula, you should now have a column that copies the values of the selected range.

Summary

This guide should be everything you need to copy values and not formulas in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.