MS Excel Shortcut Key's

Shortcut key              Description

Alt + Shift + F4          Closes all the workbooks (saving first) and exits Excel (File > Exit)

Alt + Shift + F10        Displays the drop-down menu for the corresponding smart tag

Alt + Shift + F11        Activates the Microsoft Script Editor window

Ctrl + Shift + F3        Displays the (Insert > Name > Create) dialog box

Ctrl + Shift + F6        Moves to the previous open workbook or window

Ctrl + Shift + F10      Activates the Menu Bar or Shortcut Characters in 2007

Ctrl + Shift + F12      Displays the (File > Print) dialog box

Ctrl + 0                       Hides the columns in the current selection

Ctrl + 1                       Displays the formatting dialog box

Ctrl + 2                       Toggles bold on the current selection

Ctrl + 3                       Toggles italics on the current selection

Ctrl + 4                       Toggles underlining on the current selection

Ctrl + 5                       Toggles the strikethrough of text on the current selection

Ctrl + 6                       Toggles between hiding, displaying

Ctrl + 8                       Toggles the display of Outline symbols on the active worksheet

Ctrl + 9                       Hides the rows in the current selection (Format > Row > Hide)

Ctrl + Shift + 0          unhide the columns in the current selection

Ctrl + Shift + 2          Enters the value from the cell directly above into the active cell

Ctrl + Shift + 8          Selects the current region (surrounded by blank rows and columns)

Ctrl + Shift + 9          unhide the rows in the current selection

Ctrl + A                      Displays formula palette given a function name or selects the whole worksheet or current date

Ctrl + B                      Toggles bold on the current selection

Ctrl + C                      Copies the current selection to the clipboard

Ctrl + D                      Copies the first cell in the selection downwards

Ctrl + F                      Displays the Find dialog box

Ctrl + G                      Displays the GoTo dialog box

Ctrl + H                      Displays the Replace dialog box

Ctrl + I                       Toggles italics on the current selection

Ctrl + K                      Displays the Insert Hyperlink dialog box

Ctrl + L                      Displays the Create Table dialog box

Ctrl + N                      Creates a new workbook

Ctrl + O                      Displays the Open dialog box

Ctrl + P                      Displays the Print dialog box

Ctrl + R                      Copies the leftmost cell in the selection to the right

Ctrl + S                       Saves, Displays the Save As dialog box if a new workbook

Ctrl + U                      Toggles underlining on the current selection

Ctrl + V                      Pastes the entry from the clipboard

Ctrl + W                     Closes the active workbook or window

Ctrl + X                      Cuts the current selection to the clipboard

Ctrl + Y                      Repeats the last workbook action Ctrl + Z Undo the last workbook action

Ctrl + Shift + F           Activates the Font Tab of the format cells

Ctrl + Shift + O          Selects all the cells with comments

Ctrl + Shift + P           Activates the Font Size tab of the format cells

Enter                          Enters the contents of the active cell and moves to the cell below (by default)

Shift + Enter              enters the contents of the active cell and moves to the cell above (by default)

Tab enters                  the contents of the active cell and moves one cell to the right