How to Clear Content in Google Sheets (in 2 Seconds)

Google Sheets is one of the most popular spreadsheets for managing and analyzing data, as well as collaborating with team members. Whether you’re working on a small or large dataset, it is essential to keep your Google Sheets organized and clean. One way to achieve this is by clearing the content of cells that are no longer needed.

To remove all the data, formulas, or formatting from a sheet, this article will provide you with a step-by-step guide on how to clear content in Google Sheets. We’ll also cover how to clear multiple cells, how to clear cell contents in Google Sheets (without deleting formulas), and getting the sleekest spreadsheet possible.

How To Clear Content in Google Sheets: A Step-by-Step Guide

Clearing cells in Google Sheets is a straightforward process that can be done manually or with a script. Here, we will explore the different ways to clear content in Google Sheets, including multiple cells (without deleting formulas).

Related: To enable screen reader support in Google Docs, press Ctrl+Alt+Z on Windows (or Command+Option+Z on Mac).

How To Clear Cells in Google Sheets

To clear the contents of a single cell in Google Sheets, follow these steps:

  1. Click on the cell with the content that you want to clear.
How to clear content in Google Sheets—click on spreadsheet cell in Google Sheets

 

  1. Click the “Backspace” or “Delete” key.
Delete cell in Google Sheets by hitting the delete button

How To Clear Multiple Cells in Google Sheets

If you need to clear multiple cells in Google Sheets:

  1. Select the cell range with the content that you want to clear.
Selection of multiple cells in Google Sheets

 

  1. Click either the “Backspace” or “Delete” button on your keyboard. Alternatively, you can click on Edit > Delete > Values.
Delete button in Google Sheets

 

Related: How to Delete Empty Rows in Google Sheets

How To Clear Contents in Google Sheets Without Deleting Formulas

When you clear the cell contents from a single cell or a range of cells, formulas included in those cells are also deleted. However, there is a way to clear the formatting without deleting the formulas:

  1. Select the cells with the formatting that you want to clear.
Deleting multiple cells in Google Sheets

 

  1. Go to the “Format” menu and choose “Clear formatting.” Otherwise, press CTRL + on Windows or CMD +  on macOS. Google Sheets will remove the formatting while leaving the formulas intact.
Clear formatting on multiple cells in Google Sheets

How To Use a Google Sheets Clear Content Script

You can use a custom script to clear formatting and content from a single cell (or multiple cells), as well as customize the script to ignore formulas. The following script will delete formatting and content but leave the original formulas intact:

```
function clearContentAndFormatting() {
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getActiveRange();
range.setValues(range.getFormulas());
range.clearFormat();
}
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Delete')
.addItem('Clear Content and Formatting', 'clearContentAndFormatting')
.addToUi();
}
```

To use this Google Sheets clear cells script:

  1. Go to the “Extensions” menu and choose “Apps Script.”
Apps Script option in Google Sheets

 

  1. Copy and paste the script above into the code.gs file.
Adding code.gs file. script in Google Sheets

 

  1. Name and save the script, close the script editor, and return to your sheet. You will now see a “Delete” menu next to “Help.”
Clear contents script in Google Docs

 

  1. Select the cells with the content and formatting that you want to clear.
Selecting multiple cells for formatting in Google Sheets

 

  1. Select “Delete” > “Clear content and Formatting.”
Clear content and formatting option in Google Sheets

 

  1. As you can see below, the script clears the selected cells’ content and formatting while leaving the SUM formula intact.
How to clear multiple cells in Google Sheets

Related: How to Delete Multiple Google Sheets at Once

Conclusion

Knowing how to clear content in Google Sheets is a simple process that can be done with a few clicks. To learn countless options from a seasoned professional, check out our Google Forms and Sheets Masterclass.

Another great method for saving time and effort? Rather than creating your own from scratch, use our collection of pre-made Google Sheets templates for various projects. Use the promo code SSP to save 50% on all templates.

Related:

Exported with Wordable

Most Popular Posts

Related Posts

Thanks for visiting! We’re happy to answer your spreadsheet questions. We specialize in formulas for Google Sheets, our own spreadsheet templates, and time-saving Excel tips.

Note that we’re supported by our audience. When you purchase through links on our site, we may earn commission at no extra cost to you.

Like what we do? Share this article!