macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Medium Priority · Version 2003

Ann-Marie has attended:
Excel Intermediate course

Macros

How do you insert a button so that I can reset autofilters in one go

RE: Macros

Hello Ann-Marie

Thank you for your question.

You can clear all autofilter settings by going to Data - Filter and selecting Clear All.

If you wish to have a toolbar button to do this, go to Tools - Customise, then select the Commands tab. Select Data from under Categories on the left, then on the right find the Show All command. Drag and drop the Show All command onto a toolbar, where you want the button positioned, then click Close.

I hope you find this useful.
Amanda


 

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips


Server loaded in 0.09 secs.