See all How-To Articles

How to Clear Cell Contents in Excel & Google Sheets

This tutorial demonstrates how to clear the contents of multiple cells at once in Excel and Google Sheets.

 

clear cell contents initial data

 

Clear Cell Contents

If you delete rows or columns in Excel, all cells are shifted accordingly. However, you can also delete only cells content without shifting. Say you have the following data set.

 

clear cell contents initial data

 

If you want to delete only values from Row 4 (range B4:E4), first select the range to clear (B4:E4). Then in the Ribbon, go to Home > Clear > Clear All (or use the keyboard shortcuts).

 

clear cell contents 1

 

As a result, cells in Row 4 are now cleared, without shifting, so all other cells are unchanged.

 

clear cell contents final data

 

Note: You can also use VBA code to clear cell contents.

Clear Contents in Google Sheets

To clear cell contents without shifting in Google Sheets, follow these steps:

Select the data range you want to clear (B4:E4), and in the Menu, go to Edit > Delete values.

 

google sheets clear content

 

In this case, cell content is deleted, but the formatting remains.

 

google sheets clear content final

 

To clear all formatting, select the same range (B4:E4), and in the Menu, go to Format > Clear formatting (or use the keyboard shortcut CTRL + \).

 

google sheets clear content final 2a

 

Now, all content and formatting are cleared from the selected range of cells.

 

google sheets clear content final 2