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

vba excel - filtering

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba excel - Filtering

vba excel - Filtering

ResolvedVersion Standard

David has attended:
Excel Intermediate course
Excel Advanced course

Filtering

If I have filtered many of the columns, how do I quickly take all the filters off so that all the information on the worksheet can be displayed.

Hope you can help?

RE: Filtering

In "Data" menu, select "Filter", then "Show All"

RE: Filtering

Thanks, I thought it would be something simple.

RE: Filtering

Hi David,

Thanks for the question,

The quickest way to take all the filtering off would be to go into the Data menu and go down to Filter and across to the option that says AutoFilter. Alternatively, you could also put this up on your toolbar as a shortcut so instead of using the menus you can use the buttons. If you want help on how you would go about that let me know

Hope that helps

Tracy

RE: Filtering

Thanks for your help.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.