Key Takeaways
In Excel, actions are associated with F1 through F12, standalone, and combined with keys like Alt, Ctrl, and Shift.
Some of the most commonly used function shortcuts are Ctrl + F12 to open a document and Ctrl + F3 to open the Name Manager dialog.
F1 Shortcuts
Shortcut Key Action F1 Opens the Excel Help task pane. Ctrl +F1 Hide/Unhide the taskbar. Alt +F1 Create a chart from data in the current range. Ctrl +Shift +F1 Hide/Unhide ribbon and taskbar. Alt +Shift +F1 Create a new worksheet.
F2 Shortcuts
Shortcut Key Action F2 Activates the active cell for editing. Ctrl +F2 Open print options. Alt +F2 Open file Save as mode window. Shift +F2 Insert/Edit comments on selected cells. Alt +Shift +F2 Save the current workbook.
F3 Shortcuts
Shortcut Key Action F3 Paste a defined name into a formula. Ctrl +F3 Open the Name Manager dialog box. Shift +F3 Open the function insert dialog box. Alt +F3 Opens the Function Arguments dialog box Ctrl +Shift +F3 Open the Create name from selection box.
F4 Shortcuts
Shortcut Key Action F4 Cycles all your 4 cell reference types. Ctrl +F4 Close the current workbook. Alt +F4 Gives option to save or discard current changes. Shift +F4 Select the cell right to the current. Selection toggles until the cell containing data goes to the next row. Ctrl +Shift + F4 Repeat the last action (for example, create a text box) or toggle among cell references.
F5 Shortcuts
Shortcut Key Action F5 Opens the Go To dialog box Ctrl +F5 Restores the window size of the open workbook Shift +F5 Open Find/Replace dialog box.
F6 Shortcuts
Shortcut Key Action F6 Switch between the Help task pane and the application window. Switch to the next pane in a worksheet that has been split. Shift +F6 Allows you to access several options by displaying numbers and alphabets that serve as shortcuts.
F7 Shortcuts
Shortcut Key Action F7 Perform spell check in the selected range. Ctrl +F7 Activate move window cursor provided window is not maximized. Shift +F7 Open thesaurus.
F8 Shortcuts
Shortcut Key Action F8 Turn the Extend mode on/off. Ctrl+F8 Activate a resize window cursor provided the window is not maximized. Alt+F8 Open the Macro dialog box. Shift+F8 Enable Add to Selection mode – select non-adjacent cells when enabled.
F9 Shortcuts
Shortcut Key Action F9 Refreshes workbook. Performs calculations on formulas. Ctrl +F9 Minimize workbook. Shift +F9 Calculate the active worksheet Ctrl +Alt +F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Ctrl +Alt +Shift + F9 Recheck dependent formulas and then calculates all cells in all open workbooks.
F10 Shortcuts
Shortcut Key Action F10 Allows you to access several options by displaying numbers and alphabets that serve as shortcuts. Ctrl+F10 Maximize or restore the selected workbook window. Shift+F10 Display the shortcut menu for the selected item.
F11 Shortcuts
Shortcut Key Action F11 Create a chart of the data in the selected range. Ctrl+F11 Create a new worksheet with names like Macro1, Macro2… Alt+F11 Switch between the visual basic editor and the active workbook. Shift+F11 Create a new worksheet. Alt+Shift+F11 Open Microsoft script editor.
F12 Shortcuts
Shortcut Key Action F12 Open save as dialog box. Ctrl+F12 Open the open menu. Shift+F12 Save the current workbook. Ctrl+Shift+F12 Open the print menu. (A good option if you are unable to print )
Thanks for your feedback!
How to Use the Filter and Sort Data Function in Microsoft Excel
Things to Note About Using the Filter and Sort Function The Filter function allows you to extract data from a data set that fits your criteria.
3 Ways to Fix Keyboard Function Keys Not Working on Windows 11/10
Fix 1: Confirm Shortcut Keys Don't Disable Function Keys Keyboards with an Fn key allow two sets of actions on the function keys.
The Complete List of Microsoft Paint Keyboard Shortcuts
File Management Shortcuts ShortcutFunctionCtrl + NCreate a new imageCtrl + OOpen a fileCtrl + WResize and Skew an imageCtrl + PPrintAlt + F4CloseF12Save as - It prompts for a new
5 Fixes for Keyboard Shortcuts Not Working in Microsoft Excel for Windows
Fix 1: Use the On-Screen Keyboard First, you must perform a few keyboard shortcuts using the On-Screen Keyboard (OSK) on Windows.
Top 7 Ways to Fix Windows Key Not Working on Windows 10
Windows 10 operating system is full of keyboard shortcuts.
7 Ways to Fix Windows Key Not Working in Windows 11
Basic Fixes Check for physical damage: There might be physical damage or dirt buildup on your keyboard.
3 Quick Ways to Find Product Key on Windows 10 or Windows 11
1.
4 Ways to Fix Tab Key Not Working on Windows 11
Try These Fixes First Restart your computer: The Issue can occur due to a temporary bug or glitch on your computer.
