In this article:

How to Clear Contents in Google Sheets (Easiest Way in 2025)

January 13, 2025

How to Clear Contents in Google Sheets

Follow the steps below to clear contents in Google Sheets. 

1. Select the Cells You Want to Clear in the Document

Identify and select the cells you wish to clear in your open document. You can select a range of cells by clicking and dragging or select individual cells by clicking on each.

how to clear contents in google sheets

2. Access the Edit Menu for More Options

With the cells selected, go to the top menu bar and click on "Edit" to reveal a dropdown menu with various editing options.

3. Choose "Delete" Then Select "Values" to Clear Cell Contents

In the "Edit" dropdown menu, hover over or click on "Delete" to expand its options. Then, select "Values" to remove the contents of the selected cells without deleting the cells themselves.

clear contents google sheets

4. Verify That the Selected Cells Are Now Empty

Inspect the cells you selected earlier to ensure that all contents have been successfully cleared.

clear contents in google sheets

We hope that you now have a better understanding of how to clear contents in Google Sheets. If you enjoyed this article, you might also like our article on how to embed Google Sheets or our article on Google Sheets trim.

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages