Clear Cell Contents in Google Sheets: 4 Ways

Clearing cell contents in Google Sheets removes the data, text, or formulas inside cells while leaving the cells themselves and their formatting intact. This guide covers the fastest methods—Delete key, right-click, Edit menu, and a shortcut for clearing everything—so you can clean up a sheet without deleting rows, columns, or your carefully applied styles.

What You’ll Need

A Google account and a Google Sheets document open in your browser
The specific cells, row, or column you want to clear
No special permissions needed—just edit access to the sheet

Step-by-Step

Select the cells you want to clear. Click and drag over a range, or click a single cell. To select an entire row or column, click its row number or column letter. For multiple non-adjacent ranges, hold Ctrl (Windows) or Cmd (Mac) while clicking.
Press the Delete or Backspace key. This instantly clears the contents of all selected cells. It does not remove formatting, comments, or data validation rules.
Alternative: Use the right-click menu. Right-click the selected range, choose Delete, and then select Delete values from the submenu. This does the same as pressing Delete but is handy if you prefer menus.
Alternative: Use the Edit menu. Click Edit in the top menu bar, then select Delete and Delete values. This works exactly like the right-click option.
To clear formatting as well, use Clear > Formatting. If you want to remove both contents and formatting (like colors, bold, or borders), select the cells, go to Format > Clear formatting, or use the shortcut Ctrl+\ (Windows) or Cmd+\ (Mac). Note this only clears formatting, not contents—so you’d need to do both steps.
To clear everything including formatting and comments, use Clear > All. Select the cells, click Edit > Delete > Delete all. This resets the cells to completely blank, removing contents, formatting, comments, and data validation rules.
For a blank slate, delete the rows or columns entirely. If you want to remove the cells themselves and shift surrounding data, right-click the row number or column letter and choose Delete row or Delete column. This is different from clearing contents—it removes the cells and shifts data up or left.

Common Mistakes

Confusing “Delete” with “Clear.” In Google Sheets, “Delete” often means removing rows or columns, not just the values. Always choose “Delete values” or use the Delete key to avoid accidentally shifting your data.
Pressing Delete when a cell is in edit mode. If you double-click a cell and the cursor is blinking inside it, pressing Delete only deletes one character, not the whole cell. Click outside the cell first to exit edit mode.
Expecting formatting to be cleared. The Delete key and “Delete values” do not remove background colors, bold, or number formats. Use “Clear formatting” or “Delete all” if you need a full reset.
Clearing hidden cells. If you have hidden rows or columns, selecting a range that includes them will clear those hidden cells too—even though you can’t see them. Unhide first if you want to avoid that.

Tips

Use keyboard shortcuts for speed. Press Delete to clear contents, Ctrl+\ (Windows) or Cmd+\ (Mac) to clear formatting, and Ctrl+Z (or Cmd+Z) to undo if you make a mistake.
Clear a whole sheet quickly. Click the triangle in the top-left corner (where row numbers and column letters meet) to select all cells, then press Delete. This clears every cell’s content on the sheet.
Use “Delete all” for a true reset. When you’re repurposing a template, “Edit > Delete > Delete all” ensures no hidden formatting or validation rules linger and cause surprises later.
Be careful with formulas. If you clear a cell that contains a formula, it’s gone—there’s no undo after you close the sheet. Double-check that you don’t need the formula before clearing.
Consider using “Find and replace” to clear specific values. Press Ctrl+H (or Cmd+H), leave “Find” blank, and type what you want to remove in “Replace with” to clear only cells matching a certain value.

Troubleshooting

Nothing happens when I press Delete. Make sure you’ve selected cells and that the sheet isn’t protected. If the sheet is shared with “Viewer” or “Commenter” access, you can’t edit. Check the sharing settings or ask the owner for edit access.
I cleared cells but they still show old values. You might have selected the wrong range, or the cells contain array formulas that recalculate. If an array formula (like =ARRAYFORMULA(...)) is in the way, you need to clear the top-left cell of that array first, or delete the entire array range.
Formatting won’t go away. Use “Format > Clear formatting” specifically. If that doesn’t work, the formatting might come from conditional formatting rules. Go to “Format > Conditional formatting” and remove any rules that apply to those cells.
I accidentally cleared the wrong cells. Immediately press Ctrl+Z (or Cmd+Z) to undo. If you’ve closed the sheet, check the version history: “File > Version history > See version history” to restore an earlier version.
Data validation or dropdowns still appear after clearing. That’s expected—clearing contents doesn’t remove validation. To remove the dropdown, select the cells, go to “Data > Data validation,” and click “Remove validation.”

Frequently Asked Questions

Does clearing cells delete the row or column?

No. Clearing contents only removes the values inside the cells. The rows and columns remain in place. To delete the entire row or column, right-click the row number or column letter and choose “Delete.”

What’s the difference between “Delete values” and “Delete all”?

“Delete values” removes only the text, numbers, and formulas. “Delete all” also removes formatting, comments, and data validation rules, returning the cells to a completely blank state.

Can I clear cells without affecting formulas in other cells?

Yes, clearing a cell only removes its own content. If other cells reference that cell, they will show an error (like #REF! or #VALUE!) because the referenced value is now empty. You may need to update those formulas.

How do I clear only numbers but keep text?

Use “Edit > Find and replace” (Ctrl+H). In “Find,” enter a pattern like \d+ (if you enable “Search using regular expressions”), leave “Replace with” blank, and choose “Replace all.” This removes numeric values while leaving text intact.

Why can’t I clear cells in a protected range?

If the sheet owner has protected a range, only people with edit permission for that range can modify it. You’ll see a message when you try. Ask the owner to adjust the protection settings.

Does clearing cells affect my undo history?

Yes, clearing cells is an undoable action. You can press Ctrl+Z (or Cmd+Z) to restore the cleared contents immediately. However, if you make many changes and then close the sheet, you may not be able to undo all of them—use version history for a more robust recovery.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →