How Do I Delete The Data In Cells In Google Sheets

Clear data by blazon in Google Sheets

Power Tools provides you lot with various utilities to speed up nearly of your daily tasks. Larn how to piece of work with the Clear tool to remove blank rows and columns, numbers or text, dates and notes, delete formatting, hyperlinks, and Booleans in your Google spreadsheet.

Before y'all beginning
How to clear data
- Run the Clear tool
- Clear data by type
- Remove empty rows and columns
Related pages

Earlier yous first

The Clear tool also handles cells in filtered & hidden rows & columns.

How to articulate information

Run the Articulate tool

Go to Extensions > Power Tools > First to open the improver in Google Sheets:
Click on the Clear icon on the add-on sidebar:

Clear data by type

Select the range with your cells and tick off the checkboxes next to the data types you'd like to remove:
Clear various types of data from the selected range.

Select the Clear all option to erase all types of data including images and formatting in the selected range.
Choose to Articulate formatting to reset formatting to default in all cells of involvement.
Check the Clear numbers option to remove all cells formatted as numbers in the highlighted range.
Clear hyperlinks volition unlink all cells with hyperlinks within the range.
Tick off Clear formulas to go rid of all formulas in the selected range.
Use Clear dates to remove all date-formatted cells.
Clear notes allows you lot to delete all notes in the range in one click.
Select the Clear text option to delete all cells formatted as text in the range.
Decide to Clear booleans to remove all Truthful and Faux boolean values from the cells.
Have all Data validation rules removed from all cells in the choice using the Clear validation option.

Press Clear and all the data types yous picked will be removed from the range of your option.

Remove empty rows and columns

The options from the bottom cake permit you lot remove empty rows and columns. You can apply them with or without the Clear options. Tick off the checkboxes next to any you want to delete:
Choose to delete empty rows and columns.

Remove all empty rows
Pick this selection to delete all blank rows within the data in your sheet.
Remove all empty columns
Similarly, choose to delete all blank columns within your data.
Remove unused rows
Once your table is a complete gear up of information, you can get rid of all empty rows under it past checking this box.
Tip. Deleting unused rows helps to make your spreadsheet smaller and contributes to processing information faster and easier.
Remove unused columns
The same fashion you can delete all empty columns at the end of your data.
Tip. This choice will lighten your spreadsheet and make it easier to procedure your data.
Remove from all sheets
Have the tool remove all empty and/or unused rows and/or columns from the entire spreadsheet in one go.