Buy Now

How to Remove Formula And Keep Value in Google Sheets

google sheets Mar 06, 2023

Do you need help with frustrating formula errors that keep changing your values in your Google Sheets document?

We've got you covered!

You've come to the right place with three different methods below to remove formulas and keep values in Google Sheets.

Read on as we cover the following:

  • How to remove/convert formulas and keep values with three different methods.

  • Final thoughts on removing a formula and keeping the value in Google Sheets.

  • Frequently asked Questions on removing formulas and keeping the value in Google Sheets.


Read Also: How to Change Currency in Google Sheets

How to Remove/Convert Formulas and Keep Values: 3 Different Methods.

Remove/convert formulas and keep values via the edit menu tab.

  1. Prepare data of table with formula each cell "B2:B11."convert formulas to values.

  2. Select all the cells with formulas, navigate to Edit Menu Tab, and select "Copy."

  1. After clicking the "Copy" option, navigate to "Paste Special" and click "Paste Values"/"Paste Values Option."Paste as Values in your google sheet.

  1. As you check the cell B column, you will notice the cells are converted formulas to values in the formula bar.

    Convert Formula to Values


Read Also: How to Remove Duplicates in Google Sheets Without Using Apps Script

How to remove/convert formulas and keep values with a keyboard shortcut.

  1. Select the cells containing formulas.

  1. Press "Ctrl + C."

  1. Press "Ctrl + Shift + V," and you will notice the cells in column b will no longer contain formulas.

How to remove/convert formulas and keep values using the right-click

  1. Select the cells that contain formulas.

  1. Right-click the cells and click the "Copy" option.

  1. Click "Paste Special" and "Values Only."

  1. You will notice the cells in column b will no longer contain formulas.

Final Thoughts on How to Remove a Formula and Keep the Value in Google Sheets.

Now that you have learned how to remove formulas and retain values in Google Sheets with the three methods mentioned above, you will no longer experience frustrating formula errors! We also have an article on removing Formulas in Excel (While Keeping the Data).

You can visit our home page for more easy-to-follow how-to and step-by-step guides. Check the links in related articles for further details about Excel/Google Sheets Templates!


Read Also: How To Search in Google Sheets?

Frequently Asked Questions on How to Remove Formula and Keep Value in Google Sheets:

How can I keep the formula instead of a value in Google Sheets?

  1. Use a keyboard shortcut.

  2. Open your spreadsheet.

  3. Make sure the sheet with your data is selected.

  4. Press Ctrl + ` on the keyboard.

How do I copy and paste a formula while keeping one cell that will not be changed?

  1. Click on the cell with the formula.
  2. Press Ctrl+C to copy it.
  3. Click on the cell you want to put it in and press Ctrl+V. 

What is the keyboard shortcut when I need to remove formulas?

Choose the column where you want to take away the formulas. To do it quickly, choose the first cell in the column and press Ctrl+Shift+Down on your keyboard.

Related Articles:

How To Remove Formula in Excel (While Keeping the Data)

How to Remove Duplicates in Excel

How to Create a Google Sheets Drop-Down List

Want to Make Excel Work for You? Try out 5 Amazing Excel Templates & 5 Unique Lessons

We hate SPAM. We will never sell your information, for any reason.