In this article:

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

May 8, 2024

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.

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 ->