remove data button

  • Thread starter Thread starter fujimi-cho
  • Start date Start date
F

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
 
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
 
Back
Top