Sunday, December 26, 2010

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.

1 comment:

  1. Need more...BOSS....... Sayak....

    ReplyDelete