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

filters

ResolvedVersion 2003

Elise has attended:
Excel Intermediate course

Filters

Is there a way of getting rid of all filters on a large worksheet. If so, is there a keyboard function?

RE: Filters

Hi Elise

Thank you for your question. You can clear filters by going to the Data menu then Filters > Show all.

I have found a keyboard equivalent too.
Tap the Alt key (then let go) follwed by D then F and finally S
This will drop the filter criteria whilst leaving auto filter enabled.

I hope this helps - do let me know if you have any further questions.

Kind regards,
Andrew

RE: Filters

Excellent, thank you very much.

Elise

 

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:

Outlining - Grouping rows or columns

Highlight want you want to group and press ALT + SHIFT + left cursor arrow

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.08 secs.