In this article:

How to Remove Formulas in Google Sheets (2024 Update)

May 8, 2024

How to Remove Formulas in Google Sheets

Below we outline the steps on how to remove formulas in Google Sheets:

Step 1: Select the Cell(s) with Formulas

Single Cell: Click on the cell that contains the formula you want to delete.

remove formulas in google sheets

Multiple Cells: Click and drag your mouse over a range of cells to select multiple cells with formulas.

how to remove formulas in google sheets

Entire Column/Row: Click on the letter at the top of the column or the number at the start of the row to select all cells in that column or row.

how to remove all formulas in google sheets

Step 2: Remove the Formula

If you want to remove the formula but keep the result or value it produced in the cell, you’ll first need to copy the result. Press Ctrl + C (Windows) or Cmd + C (Mac) to copy the displayed value in the cell. Then, use Ctrl + Shift + V (Windows) or Cmd + Shift + V (Mac) to paste the value back into the cell without its formula. This effectively removes the formula but keeps the value.

how to remove formulas from google sheets

Below are the copied values without the attached formulas:

remove a formula google sheets

If you simply want to remove both the formula and its content, simply press the Delete key (or Backspace on Mac) after selecting the cells. This action will remove both the formulas and their calculated results.

How to Remove All Formulas in Google Sheets

If you need to remove formulas from a large area or the entire sheet, the fastest way is to select the area or press Ctrl + A (Windows) or Cmd + A (Mac) to select all cells in the sheet. Then, follow the steps above to either replace formulas with their values or delete everything.

We hope that this article has helped you and given you a better understanding of how to remove formulas in Google Sheets. If you enjoyed this article, you might also like our articles on how you can make a wedding budget tracker in Google Sheets and how to use the REPT function in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->