Shortcut to AutoFilter

One of the most frequently used feature of Excel is the autofilter. Most power users tend to use Alt+D-F-F for turning the filter on. Excel gives a shortcut for this... "Shift+Ctrl+L".


Shift+Ctrl+L provides the ease of applying or removing filter.


This is applicable for 2003 version onwards.

Comments

Post a Comment

Popular posts from this blog

Keyboard Shortcut to add/delete rows or columns in Excel

Alternative for SUMIF and SUMIFS

Shortcut to Copy the contents of the cell above or on the left