Other + Function

Alt + F1Creates an Embedded Chart (on the active worksheet) using the highlighted range as the data source.
Alt + F2Displays the Save As dialog box.
Alt + F4Closes the active workbook or window (saving first).
Alt + F8Displays the Macro dialog box.
Alt + F11Toggles between the Visual Basic Editor window and the Excel window.
Alt + Ctrl + F2Displays the Open dialog box.
Alt + Ctrl + F3Displays the New Name dialog box.
Alt + Ctrl + F4Closes the active workbook or window (saving first).
Alt + Ctrl + F9Full Calculation. Calculates All the worksheets in All the open workbooks.
Alt + Shift + F1Inserts a new worksheet (before the active sheet) into the active workbook.
Alt + Shift + F2Displays the Save As dialog box.
Alt + Shift + F4Closes the active workbook or window (saving first).
Alt + Shift + F10Displays the drop-down menu for the smart tag indicator that is showing in the active cell.
Alt + Shift + F11Redundant see last table below.
Ctrl + Shift + F1Toggles full screen.
Ctrl + Shift + F3Displays the Create Names from Selection dialog box.
Ctrl + Shift + F4Repeats and finds the previous match. Selects the next empty cell on the left inside the used range of the active worksheet.
Ctrl + Shift + F6Moves to the previous open workbook or window.
Ctrl + Shift + F9This 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 + F10Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
Ctrl + Shift + F12Displays the Print Options on the File tab.
Ctrl + Alt + Shift + F2Displays the Print Options on the File tab.
Ctrl + Alt + Shift + F4Closes the active workbook or window (saving first).
Ctrl + Alt + Shift + F9Full 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 the active workbook or window (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).

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext