Ads Top

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:

Powered by Blogger.