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

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