Sunday, 2 March 2014

Short Cuts 2

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 Minimises the size of the active workbook or window


Ctrl + F10 Maximises 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)


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



No comments:

Post a Comment