The function keys are often the most overlooked set of keys on the keyboard. Usually just sitting up there collecting dust.
But in Excel, the function keys are extremely useful. So, in this post I’m sharing 27 Excel function keys shortcuts that will save you time, simplify your tasks, and unlock hidden features you might not know about.
Whether you’re a beginner or a seasoned Excel user, these tips will help you work smarter, not harder.
Video TutorialWatch on YouTube & Subscribe to our Channel
DownloadDownload our FREE Excel Shortcuts PDF with over 270 shortcuts for Windows, Mac, and Web
Click here to Download the Free Guide
F1: Help, Ribbon Control, and Full Screen ModeControl + F1: Hide or Show the RibbonWhen you want to declutter your Excel window and see more rows, pressing Control + F1 hides the ribbon. This frees up space and makes it easier to focus on your data. Press the same keys again to bring the ribbon back.
Control + Shift + F1: Toggle Full Screen ModeThis shortcut hides not only the ribbon but also the title bar and quick access toolbar, putting Excel into full screen mode. It’s perfect when you want to maximize your workspace. Press Control + Shift + F1 again to exit full screen mode.
Alt + F1: Instantly Create a ChartNeed a quick visual? Select your data and press Alt + F1 to create a chart right away. If your data is in a Pivot Table, this shortcut creates a Pivot Chart instead, saving you several steps.
F1: Get Help for FunctionsWhile editing a formula, place your cursor inside a function and press F1. Excel will open the help menu for that specific function, guiding you through its usage and parameters.
F2: Edit Cells and Rename Files QuicklyF2: Edit Cell ContentsF2 is one of the most popular shortcuts in Excel. It lets you edit the active cell directly, showing the formula or content inside. After editing, press enter to save or escape to cancel.
Control + F2: Edit in Formula BarIf you prefer editing in the formula bar, press Control + F2 to focus there. This is especially handy for longer formulas or when you want better visibility while editing.
F2: Rename Files in File ExplorerHere’s a little pro tip: outside Excel, in File Explorer, pressing F2 lets you quickly rename the selected file. It’s a universal shortcut that comes in handy beyond just Excel.
Note for Laptop UsersOn laptops or compact keyboards, you might need to press the FN key along with function keys. Some keyboards have a function lock to toggle this behavior.
A quick Google search for your specific model will help you set this up.
F3: Manage Named Ranges with EaseControl + F3: Open Name ManagerThe Name Manager is a great tool when working with named ranges, Lambdas, or Excel tables. Press Control + F3 to open it. Here, you can:
This shortcut keeps your workbook organized and makes working with complex formulas much easier.
F4: Absolute References and Repeat Last ActionUse F4 to Toggle Absolute and Relative ReferencesWhen writing formulas, you often need to lock cell references. Select the cell or reference in the formula, then press F4 to add dollar signs, making it absolute (e.g., $G$2). Press F4 repeatedly to cycle through:
This is essential for copying formulas correctly across cells.
F4 to Repeat Last ActionAnother handy use of F4 is repeating your last action. For example, if you fill a cell with yellow color, select another cell and press F4 to apply the same fill color. You can keep pressing it to repeat the action on multiple cells.
F5: Navigate and Select Cells QuicklyF5 or Control + G: Open Go To DialogPressing F5 or Control + G opens the Go To dialog box. This is great for jumping to any cell, named range, or table in your workbook. Simply type the reference or select from the list and hit enter.
Go To Special: Select Specific CellsWithin the Go To dialog, click Special to select cells based on criteria such as:
This feature is incredibly useful when auditing or editing complex worksheets.
Alt + F5 and Control + Alt + F5: Refresh DataWorking with Pivot Tables or Power Query? Press Alt + F5 to refresh the selected Pivot Table or query. To refresh all tables and queries in the workbook, use Control + Alt + F5.
If you forget these, you can also find the shortcut by hovering over the Refresh All button on the Data tab.
F6: Navigate Between Workbook ElementsPress F6 to Cycle Through Excel AreasF6 cycles focus through different parts of the Excel window:
Use arrow keys to navigate tabs and hit enter to select.
Control + F6: Switch Between Open WorkbooksIf you have multiple Excel workbooks open, press Control + F6 to switch between them. It’s a handy way to toggle without reaching for your mouse.
Alternatively, Control + Tab also toggles between workbooks, and many users prefer it, especially if they use Alt + Tab to switch between applications.
F7: Spell Check and ThesaurusF7: Run Spell CheckPress F7 to launch the spell check window. This tool scans your worksheet for misspelled words and offers suggestions. You can double click a suggested correction to apply it.
Spell check also works inside shapes and text boxes, which many users overlook.
Shift + F7: Open ThesaurusIf you want to find synonyms or alternate words, select text within a cell and press Shift + F7. This opens the thesaurus for quick word suggestions.
F8: Extend Selection and Macro WindowF8: Toggle Extend Selection ModeSometimes when selecting cells, you might accidentally hit F8. This puts Excel into extend selection mode, where selecting one cell extends the selection range. The status bar will show “Extend Selection”.
Press F8 again or Escape to turn off this mode and return to normal selection.
Alt + F8: Open Macro WindowPress Alt + F8 to open the macro dialog box. Here you can:
This is a powerful tool for automating repetitive tasks in Excel.
F9: Manual Calculation and Formula EvaluationF9: Calculate Workbook ManuallyIf your workbook is set to manual calculation mode to improve performance, press F9 to calculate all formulas in the workbook. This is faster than switching back to automatic calculation.
Shift + F9: Calculate Active WorksheetTo calculate only the current worksheet, use Shift + F9. This saves time if you’re working with large workbooks.
F9: Evaluate Parts of a FormulaWhen editing a formula, select a part of it (like a function or expression) and press F9 to see the result. This replaces the selected part with its calculated value temporarily. Press Escape if you don’t want to keep the change.
Note: In Microsoft 365, Excel can now show calculation results as screen tips when you select parts of a formula, reducing the need to press F9.
Alt + F10: Manage Shapes and ObjectsOpen the Selection PanePress Alt + F10 to open the Selection Pane. This pane lists all shapes, charts, slicers, and other objects on the sheet.
You can:
This is especially useful when working with complex dashboards.
Alt + F11: Open the VBA EditorAccess the Developer WorldOne of the most powerful shortcuts is Alt + F11, which opens the Visual Basic for Applications (VBA) editor. Here you can write macros to automate tasks not possible with regular Excel functions.
Learning VBA can save you hours of repetitive work and unlock advanced capabilities.
Watch Out for MistakesIf you forget to press Alt and just press F11, Excel will insert a new chart sheet based on the selected data. It’s easy to fix by right-clicking and deleting the unwanted sheet.
Shift + F11 and F12: Insert New Sheet and Save AsShift + F11: Insert a New WorksheetPress Shift + F11 to quickly add a new worksheet to your workbook. It’s faster than right-clicking and choosing “Insert”.
F12: Open Save As WindowF12 opens the Save As dialog, allowing you to rename your file, choose a save location, or change the file type. This shortcut also works across other Office apps like Word and PowerPoint.
Alt + F12: Open Power Query EditorIf you use Power Query for data transformation, Alt + F12 opens the Power Query editor window directly, saving you time navigating through the ribbon.
Conclusion: Unlock Your Excel Potential with Function KeysExcel function keys shortcuts are a hidden treasure trove for anyone looking to boost their productivity. From editing cells with F2 to managing macros with Alt + F8 and navigating complex workbooks with F6, these shortcuts save time and simplify your work.
Remember, the best way to get comfortable with these shortcuts is to practice them regularly. Start by mastering a few that fit your workflow, then gradually add more to your toolkit.
Which Excel function keys shortcuts are your favorites? Have I missed any gems? Leave a comment and share your tips.
Don’t forget to download the free Excel shortcuts guide packed with over 270 shortcuts for Windows, Mac, and the web. It’s a great resource to take your Excel skills to the next level.
Happy Exceling!
Link to post: 27 Excel Function Key Shortcuts that Save Time & Unlock Hidden Features