How To Clear Cells In Google Sheets

In this tutorial, you will learn how to clear cells in Google Sheets.

How To Clear Cells In Google Sheets

Working with spreadsheets isn’t all adding data and formatting. Sometimes you need to remove data and formatting as well.

Clear Data From Cells

To clear data from a cell or range, simply select the cell or range you want to clear and hit backspace or delete on your keyboard.

You can also clear content from cells using the menu.

To do this:

  1. Select the cells you want to clear
  2. Open the Edit menu
  3. Select Delete Values and the cells will be cleared of data

 

Clear Formatting from Cells

To clear cell formatting, follow these steps:

Step 1

Select the cells you want to clear of formatting

Step 2

Open the Format menu and choose the Clear Formatting option at the bottom

Step 3

All formatting will be cleared from the selected cells

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to clear cells in Google Sheets. Want more? Check out all the Google Sheets Tutorials.