Similarly to hiding / unhiding rows, select some rows (or a range of cells over more than one row) and try
SHIFT ALT RightArrow

This "groups" the rows (puts a little [-] sign in the left margin; click it to roll it up and hide them.)

I prefer this method to ordinary "hide rows" because the [+] sign tells you that there are hidden rows lurking. Without that, it can be hard to notice the gap in row numbers or the one-pixel-thicker separator.

To ungroup the rows ("unhide"), use SHIFT ALT LeftArrow.

This appears to work with only rows or columns that are adjacent. Are there any slick ways to hide/unhide several columns that are not adjacent?

In my formula, I have "+A1 * C1" I'd like the A1 to read $A$1. Is there a way, when I click A1 to add it to my formula to make it that way? It becomes a pain to create my formula, hit F2, edit it and then copy it.

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.

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)

and 'alt+dfa Enter' for advanced, while sitting anywhere in the criteria range or database range. (Advanced filtering is not that difficult and has some fine advantages, though often eschewed. It's easier when you define range Criteria and Database. http://www.contextures.com/xladvfilter01.html is good primer. Add additional keystrokes for the garbage-interfaced XL2007.)

If it hasn't been mentioned already, with autofiltering you can nicely capitalize on alt-down arrow and first letter recognition. [Edit: I just checked: first letter recognition seems to have been assassinated in the 2007 interface. Those j/o's.]

Last edited by GatesIsAntichrist; 06-04-2009 at 10:50 AM..
Reason: correction for Excel version difference in results

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.

There are several features in every version of MS Office that are undocumented, and this sounds like one of them. Typically, a developer in the Office Team creates a little feature for his/her own use and, for whatever reason, is never removed. You must remain aware that such undocumented "features" may disappear in future versions or service packs.