MS Excel Shortcut Key's
Shortcut
key Description
Shift + F11
Inserts a new worksheet
(before the active sheet) into the active workbook (Insert > Worksheet)
Shift + F12
Saves, Displays the (File
> Save As) dialog box if a new workbook
Ctrl + F1
Closes and reopens the
current task pane (ribbon in 2007)
Ctrl + F2
Print Preview
Ctrl + F3
Displays the (Insert
> Name > Define) dialog box
Ctrl + F4
Closes the selected
workbook window
Ctrl + F5
Restores the size of
the active workbook or window
Ctrl + F6
Moves to the next open
workbook or window
Ctrl + F7
Activates the Move
window command
Ctrl + F8
Activates the Resize
window command
Ctrl + F9
Minimizes the size of
the active workbook or window
Ctrl + F10 Maximizes the size of the active workbook or window
Ctrl + F12
Displays the (File >
Open) dialog box
Alt + F1 Creates a chart (on a chart
sheet) using the highlighted range
Alt + F2 Displays the (File >
Save As) dialog box
Alt + F4 Closes all the workbooks
(saving first) and exits Excel (File > Exit)
Alt + F8 Displays the (Tools >
Macro > Macros) dialog box
Alt + F11
Toggles between the
Visual Basic Editor window and and the Excel window
Alt + Ctrl + F9
Calculates All cells on all
worksheets in All workbooks
Alt + Shift + F1
Inserts a new worksheet (before
the active sheet) into the active workbook (Insert > Worksheet)
Alt + Shift + F2
Displays the (File > Save As)
dialog box
Alt + Shift + F4
Closes all the workbooks (saving
first) and exits Excel (File > Exit)
No comments: