Excel Shortcut Keys 2011-12

[Vuhelper]

[B]Excel Shortcut Keys 2011-12

The shortcuts below are keyboard sequences or keys and are not keys press simultaneously. They are keyboard sequences that navigate through the old Microsoft Excel 2003 menu bar that is still supported on MS Excel 2007. Note again, not simultaneous, these are key sequences.
• Delete a Column Shortcut
Alt, E, D, C
• Delete a Row Shortcut
Alt, E, D, R
• Insert a Column Shortcut
Alt, I, C
• Insert a Row Shortcut
Alt, I, R
• Adjust width of Column to Auto-Fit highlighted cell(s) contents Shortcut
Alt, O, C, A
• Adjust height of Row to Auto-Fit highlighted cell(s) contents Shortcut
Alt, O, R, A
• Adjust width of Column Shortcut
Alt, O, C, w
• Adjust height of Row Shortcut
Alt, O, R, E
• Hide a Column Shortcut
Alt, O, C, H
• Hide a Row Shortcut
Alt, O, R, H
• Unhide a Column Shortcut
Alt, O, C, U
• Unhide a Row Shortcut
Alt, O, R, U
• Paste Special – Values Shortcut
Keyboard Right Click Button, S, V, Enter
Alt,D,F,F (Auto Filter Command)
Alt,D,G,G (Groups columns or rows)
Alt,D,G,U (Un-groups data)
Alt,D,F,A (Advanced Filter

SHIFT+F11 or ALT+SHIFT+F1
Insert a new worksheet.

CTRL+PAGE DOWN
Move to the next sheet in the workbook.

CTRL+PAGE UP
Move to the previous sheet in the workbook.

SHIFT+CTRL+PAGE DOWN
Select the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP.

SHIFT+CTRL+PAGE UP
Select the current and previous sheet.

ALT+O H R
Rename the current sheet (Format menu, Sheet submenu, Rename command).

ALT+E M
Move or copy the current sheet (Edit menu, Move or Copy Sheet command).

ALT+E L
Delete the current sheet (Edit menu, Delete Sheet command).[/B]