Power Tools provides you with various utilities to speed up most of your daily tasks. Learn how to 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.
The Clear tool also handles cells in filtered & hidden rows & columns.
Select the range with your cells and tick off the checkboxes next to the data types you'd like to remove under the Clear cells group:
Press Run and all the data types you picked will be removed from the range of your choice.
The options from the 2nd group let you remove empty rows and columns from Google sheets. Tick off the checkboxes next to whatever you want to delete:
Once the needed options are ticked off, click Clear and see the result.
The 3rd group lets you delete empty cells while shifting the data left or/and up:
Please contact us here