remove data button

[fujimi-cho]

This is probably very simple, but as a beginner I can't figure it out
Is it possible to creat a a button & place it at the top of m
worksheet that, with one mouse click, will remove all the data i
designated columns

 

[Gord Dibben]

Several methods for this.......

Select the designated columns then right-click and "Clear Contents"

Tools>Customize>Commands>Edit. Find the "Clear Contents" button and move to
your Toolbar.

Record a macro while doing the first then assign it to a button.

Gord Dibben Excel MVP