Other + Function
Alt + F1 | Creates an Embedded Chart (on the active worksheet) using the highlighted range as the data source. |
Alt + F2 | Displays the Save As dialog box. |
Alt + F4 | Closes Excel (saving first). |
Alt + F8 | Displays the Macro dialog box. |
Alt + F11 | Toggles between the Visual Basic Editor window and the Excel window. |
Alt + Ctrl + F2 | Displays the Open dialog box. |
Alt + Ctrl + F3 | Displays the New Name dialog box. |
Alt + Ctrl + F4 | Closes the active workbook or window (saving first). |
Alt + Ctrl + F9 | Full Calculation. Calculates All the worksheets in All the open workbooks. |
Alt + Shift + F1 | Inserts a new worksheet (before the active sheet) into the active workbook. |
Alt + Shift + F2 | Displays the Save As dialog box. |
Alt + Shift + F4 | Closes the active workbook or window (saving first). |
Alt + Shift + F10 | Displays the drop-down menu for the smart tag indicator that is showing in the active cell. |
Alt + Shift + F11 | Redundant see last table below. |
Ctrl + Shift + F1 | Toggles full screen. |
Ctrl + Shift + F3 | Displays the Create Names from Selection dialog box. |
Ctrl + Shift + F4 | Repeats and finds the previous match. Selects the next empty cell on the left inside the used range of the active worksheet. |
Ctrl + Shift + F6 | Moves to the previous open workbook or window. |
Ctrl + Shift + F9 | This is not a default shortcut key but some third party add-ins use this for performing a full calculation of "all" the cells in just the "active" workbook. |
Ctrl + Shift + F10 | Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys. |
Ctrl + Shift + F12 | Displays the Print Options on the File tab. |
Ctrl + Alt + Shift + F2 | Displays the Print Options on the File tab. |
Ctrl + Alt + Shift + F4 | Closes the active workbook or window (saving first). |
Ctrl + Alt + Shift + F9 | Full Recalculation. Calculates All the worksheets in All the open workbooks. (rebuilding the dependency tree and calculation chain). |
Alt + F1 Creates an Embedded Chart (on the active worksheet) using the highlighted range as the data source. |
Alt + F2 Displays the Save As dialog box. |
Alt + F4 Closes Excel (saving first). |
Alt + F8 Displays the Macro dialog box. |
Alt + F11 Toggles between the Visual Basic Editor window and the Excel window. |
Alt + Ctrl + F2 Displays the Open dialog box. |
Alt + Ctrl + F3 Displays the New Name dialog box. |
Alt + Ctrl + F4 Closes the active workbook or window (saving first). |
Alt + Ctrl + F9 Full Calculation. Calculates All the worksheets in All the open workbooks. |
Alt + Shift + F1 Inserts a new worksheet (before the active sheet) into the active workbook. |
Alt + Shift + F2 Displays the Save As dialog box. |
Alt + Shift + F4 Closes the active workbook or window (saving first). |
Alt + Shift + F10 Displays the drop-down menu for the smart tag indicator that is showing in the active cell. |
Alt + Shift + F11 Redundant see last table below. |
Ctrl + Shift + F1 Toggles full screen. |
Ctrl + Shift + F3 Displays the Create Names from Selection dialog box. |
Ctrl + Shift + F4 Repeats and finds the previous match. Selects the next empty cell on the left inside the used range of the active worksheet. |
Ctrl + Shift + F6 Moves to the previous open workbook or window. |
Ctrl + Shift + F9 This is not a default shortcut key but some third party add-ins use this for performing a full calculation of "all" the cells in just the "active" workbook. |
Ctrl + Shift + F10 Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys. |
Ctrl + Shift + F12 Displays the Print Options on the File tab. |
Ctrl + Alt + Shift + F2 Displays the Print Options on the File tab. |
Ctrl + Alt + Shift + F4 Closes the active workbook or window (saving first). |
Ctrl + Alt + Shift + F9 Full Recalculation. Calculates All the worksheets in All the open workbooks. (rebuilding the dependency tree and calculation chain). |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext