Clear data by type in Google Sheets

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 numbers or text, dates and notes, delete formatting, hyperlinks, and Booleans in your Google spreadsheet.

How to clear data by type

  1. Go to Add-ons > Power Tools > Start to open the add-on in Google Sheets:
    Start Power Tools.
  2. Click on the Clear icon on the add-on's sidebar to delete the selected types of data:
    Click the Clear icon on the Power Tools sidebar.

    Tip. You can pick Add-ons > Power Tools > Clear on the first step to see the tool's options right away.
  3. 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 and formatting in the selected range.
    • Choose to Clear formatting to reset formatting to default in all cells of interest.
    • Check the Clear numbers option to remove all cells formatted as numbers in the highlighted range.
    • Clear hyperlinks will clear all cells with hyperlinks within the range.
    • Tick off Clear formulas to get rid of all formulas in the selected range.
    • Use Clear dates to remove all date-formatted cells.
    • Clear notes allows you 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 TRUE and FALSE boolean values from the cells.
    1. Press Clear and all the data types you picked will be removed from the range of your choice.

Responses

I want to know how to clear the numbers in a spreadsheet, but not remove the formatting. It's a day by day spreadsheet that I was using as a grade average calculator for my school grades for the first semester, and I want to use it again for the next one, so I made a new folder and copy pasted the formatting into the new one, except the same numbers are still there and the spreadsheet had a lot of conditional formatting that I don't want to erase, I just want to clear the numbers and data and stuff, so that when I re-enter the data day by day, the formatting will still be there.

Reply

And also, it's on my school laptop so I can't add any add-ons because they are blocked by the school

Reply

Hello, Svara,

Thank you for contacting us and for your question.

When you delete numbers from cells manually, you clear values only, not the formatting.
The same goes for conditional formatting - it is managed via the corresponding option in the Google Sheets menu. Deleting the value from the cell doesn't remove your conditional formatting rules. As soon as the value is entered back, the rules and formatting are back to play.

If you can't use our add-on, you could apply Filter by condition to leave only numbers visible and then select them all and delete.
Another way I can think of is using Google App Script, however, to out regret we won't be able to help with that.

If you have any further questions, please contact us at support@ablebits.com.
Thank you.

Hello,
I am trying to select multiple rows in my sheet and use the clear function, the problem is that only one row is cleared. How do I clear multiple rows at one time?

Reply

Hello Steve,

Thank you for reporting a problem to us.

For us to be able to help you better, we need more details on the issue. Please send us the screenshot of the options you select in the add-on to support@ablebits.com.
Also, if it's possible, please share your spreadsheet with us at support@4-bits.com. If you have confidential information there, you can replace it with some irrelevant data, just keep the format.

This will help us understand the problem better.
Thank you.

Reply

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.