More Filtering Fun

Yesterday I quoted a tip on filters from “Learn Excel from Mr. Excel,” a great read. 

Filters are a powerful Excel feature. They allow you to hone in on your data. 

Ctrl+L

The only problem is they’re a little difficult to access. Normally it takes a few clicks to apply a filter. This keyboard shortcut will put it right on.

Note: you must have your cursor pointed somewhere within the range of data you want to filter. 

 

 

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: