One more question is there a way to select a button that would go to a sheet and clear the data from all columns? I realize this could be very dangerous if you make a mistake when setting up you could destroy your sheet. However, once you have the correct sheet selected, I’d like to be able to cle…

Working on it off and on (mostly off) for 2 years, I finally have success. I created a macro to delete rows 2-200. Then I created a column and cell for my trigger word. I created a button to enter the trigger word. Finally, set up the “on change” trigger. The clearance doesn’t happen until the …

Clear all column's data

Ask for Help

ToOFa_Apps February 20, 2022, 8:31pm 6

I managed to use the Multiple Row Reset Concept App for some ideas.
Definitely does the trick for now. Bit of a workaround but at least i don’t have to use scripting etc.

1 Like

Topic		Replies	Views
Clear Cells Ask for Help	8	1178	September 26, 2020
Clear entire column Ask for Help	4	654	September 14, 2022
OnChange trigger Ask for Help	30	6829	January 17, 2024
Use "set column" to clear all values in a column? Ask for Help	1	1655	March 3, 2021
How to clear whole column? Ask for Help actions	61	4512	November 3, 2023

Clear all column's data

Related topics