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:
Hi, I was wondering how to remove an invalid response when using dependent drop down lists and data validation. I've created a 4 dependent drop down lists for four Columns in my spreadsheet; however if I choose a different response in the first dependent drop down lists the invalid response are still populated in the other 3 dependent drop down lists. Is there a way to automatically have the cell clear if the response is invalid?
Thank you for your question. Unfortunately, our tools cannot help you with this particular task.
Thanks for getting back to me so quickly!
I just wanted to suggest you search our blog for the answer instead. We have covered dependent drop-down lists there and you may find a solution for this problem.
I am new in using spreadsheets. I use it to document the mark list of my students. Each column carries marks of each subjects and one carrying the total marks. So if I cancel one column, can I automatically change the values of total marks column? Or should I edit each pupil’s total marks separately? Need help
If you use formulas to count the totals, they will automatically adjust themselves if you delete any of the values. If you don't use any formulas yet, I'd suggest getting to know this one: SUM in Google Sheets.
I have run a merge and combine but I'm now left with a ton of rows that I don't need in my spreadsheet. They all have some data in them but one column is empty for those that I don't need.
Is there a way to have power tools delete all rows that have a specific empty field rather than me manually going in there and doing it myself?
If you can share a small sample spreadsheet with your source data and the expected result with email@example.com, we'll try to find a solution to your task. If you have confidential information in your table, you can replace it with some irrelevant data, just keep the format. Please also shorten your table to 10-20 rows.
I am looking for a script that will clear cell(s) when the value of another cell changes or is equal to ("X").
I would like when Column "G" gets checked marked (TRUE), then Columns "D" & "E" become cleared (or no value) according to the respective row that was checked (TRUE).
When "G3" is checked (TRUE), then D3 & E3 are cleared. It is important that both columns get cleared out as it affects Columns "E", "F", and "H" which all include very important information that needs to be automatically updated according to Column "G" to remove as much human error as possible.
Thank you for contacting us. I'm sorry but our add-on won't be able to help you with this task. The thing is, it's currently impossible to run the Clear tool automatically. You need to run it each time you want to remove some values. Sorry.
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?
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 firstname.lastname@example.org.
Also, if it's possible, please share your spreadsheet with us at email@example.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.
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.
And also, it's on my school laptop so I can't add any add-ons because they are blocked by the school
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 firstname.lastname@example.org.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!