View Single Post
  #48  
Old 06-04-2009, 08:12 AM
Noddy's Avatar
Noddy Noddy is offline
Member
 
Join Date: May 2007
Posts: 2,450
Default

Quote:
Originally Posted by E View Post
Found a new one by accident today in Excel 2007. Pressing CTRL+SHIFT+L while you are anywhere within a contiguous range puts autofilters at the top of each column in that range. Pressing it again removes autofilters. Doesn't work in Excel 2003. I also can't find it documented online.
This made me think to look at the ALT key way to do it and 'alt+dff' works a treat. Thanks!

(ie. works when active cell is anywhere withtin a contiguous range and it toggles. I didnt realise you didn't have to select the column headers)
Reply With Quote
 
Page generated in 0.08696 seconds with 9 queries