Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to clear contents in google sheets.
If you ever need to clear the contents of a cell or range in Google Sheets, don’t worry, it’s quick and easy to do so in just a few steps. Here’s how:
Step 1
Select the range to clear contents from. This range can be a single cell or a range. Click and drag over the cells to select a range of cells

Step 2
Hit the BACKSPACE or DELETE key on your keyboard. The contents of the cells will be deleted, but any formatting assigned to the cell will be unaffected

Step 3
Note that you can also clear contents from multiple ranges by holding down SHIFT and selecting multiple ranges before clearing the contents with DELETE or BACKSPACE

Summary
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to clear contents in google sheets. Want more? Check out all the Google Sheets Tutorials.
More ways to clean data in Google Sheets:
- Clear Cells
- Clear Formatting
- Clear Filter
- Stop Google Sheets From Rounding
- Remove Dollar Sign
- Stop Google Sheets From Deleting Zeros
- Separate First And Last Name
- Format Phone Numbers
- Change Currency
- Add Dollar Sign
- TRIM
- Split Text To Columns
- Split Text to Rows
- Split Cells
- Split Text
- Find And Replace
- Find And Replace Wildcard
- Swap Cells
- Check if a Cell is Not Empty
- SPLIT