How to use function keys in Microsoft Excel

Function keys on the keyboard are often 'forgotten' but for specific applications, they are quite useful. Microsoft Excel has some interesting features hidden behind these function keys, let's take a look.

  1. Summary of expensive shortcuts in Microsoft Excel

How to use function keys in Microsoft Excel

  1. F1 key
  2. F2 key
  3. F3 key
  4. F4 key
  5. F5 key
  6. F6 key
  7. F7 key
  8. F8 key
  9. F9 key
  10. F10 key
  11. F11 key

F1 key

  1. F1 : Get help. The operation of this function key depends on the Excel window you are viewing. For example, in the normal window, when pressing F1, it will open the Help panel. Sometimes, pressing F1 will take you to the Microsoft support page and display the articles related to the feature you are looking for.
  2. Ctrl + F1 : Hide and unhide Excel Ribbon.
  3. Ctrl + Shift + F1 : Hide and unhide Excel Ribbon, title bar and status bar at the bottom of the window to display the entire sheet.
  4. Alt + F1 : Create an embedded chart from data in the selected range.
  5. Alt + Shift + F1 : Create a new sheet.

How to use function keys in Microsoft Excel Picture 1

F2 key

  1. F2 : Turn on editing in the cell and move the mouse pointer to the end of the cell's data. If the editing feature has been disabled, when pressing this function key, it will move the mouse pointer to the formula bar.
  2. Ctrl + F2 : Open the Print window to preview and print documents.
  3. Shift + F2 : Allows you to insert or edit comments on the selected cells.
  4. Alt + Shift + F2 : Save the current workbook.

F3 key

  1. F3 : Open the Paste Name window if you have named the workbook.
  2. Ctrl + F3 : Open the name manager dialog to create and edit the set name.
  3. Shift + F3 : Open the function insert dialog.
  4. Ctrl + Shift + F3 : Open the Create Names From Selection window to create a new name using the selected rows and columns.

F4 key

  1. F4 : Repeat the last action. If you have selected a cell or a reference range, when you press F4 , Excel will switch to the available references.
  2. Shift + F4 : Repeat the last search, convenient to find search results without opening the Find and Replace window.
  3. Ctrl + Shift + F4 : This key combination has the same function as Shift + F4 but repeats the first search action.
  4. Ctrl + F4 : Close the current workbook, a save message will appear if you have made any changes on the workbook.
  5. Alt + F4 : Exit Microsoft Excel. This will close all workbooks (save changes without pressing Crtl + S ) and exit the program.

F5 key

  1. F5 : Open the Go To window , move to a range or named address.
  2. Shift + F5 : Open the Find and Replace window.
  3. Ctrl + F5 : Restore the size of the active workbook window.

F6 key

  1. F6 : Move between Ribbon, sheet, tab and status bar.
  2. Shift + F6 : Move in reverse order between Ribbon, sheet, tab and status bar.
  3. Ctrl + F6 : Switch to the next workbook window when you open multiple workbook windows.
  4. Ctrl + Shift + F6 : Switch to the previous workbook window when you open multiple workbook windows.

F7 key

  1. F7 : Perform a spell check in the selected range.
  2. Shift + F7 : Open the synonym dictionary. If you select a word and press this key combination, Excel will open the dictionary and look up the selected word.

F8 key

  1. F8 : Enable and disable extended selection mode. While in this mode, you can use the arrow keys to expand or shrink the selection of the current cell.
  2. Shift + F8 : Turn on and off the ' Add to Selection ' mode. While in this mode, you can use the arrow keys or the mouse to add nonadjacent cells to the currently selected cells.
  3. Alt + F8 : Displays the Excel Excel dialog box.

F9 key

  1. F9 : Refresh the workbook, this operation performs new calculations on all formulas.
  2. Shift + F9 : Perform calculations on the active worksheet.
  3. Ctrl + Alt + F9 : Calculate all formulas on all worksheets in all open workbooks.
  4. Ctrl + Alt + Shift + F9 : Check the formulas and then calculate all cells in all open workbooks.

F10 key

  1. F10 : Turn on or turn off key tips. Key tips display letters on menus that you can press to navigate menus and activate commands.
  2. Shift + F10 : Display context menu, similar to right click.
  3. Ctrl + F10 : Zoom in or restore the selected workbook window.
  4. Alt + F10 : Enlarge the program window.
  5. Alt + Shift + F10 : Display menu or notification for smart card. If there is more than one smart card, this combination will switch to the next smart card and display its menu or notification.

F11 key

  1. F11 : Create a chart for the data selected in a separate chart sheet.
  2. Shift + F11 : Create a new sheet.
  3. Alt + F11 : Switch between the Visual Basic Editor and the active workbook.
  4. Alt + Shift + F11 : Open Microsoft Script Editor.

F12 key

  1. F12 : Open the Save As window.
  2. Shift + F12 : Save the current workbook.
  3. Ctrl + F12 : Open the Open window.
  4. Ctrl + Shift + F12 : Open the Print window.

See more:

  1. Learn the functions of F1 - F12 keys on Windows operating system
  2. List of common shortcuts for Google Sheets on computers (Part 1)
  3. More than 60 Windows shortcuts you should memorize
4 ★ | 1 Vote

May be interested

  • How to use the FILTER function in ExcelHow to use the FILTER function in Excel
    if you regularly work with data sets in excel, you know how important it is to be able to quickly find the information you need.
  • How to use Hlookup function on ExcelHow to use Hlookup function on Excel
    hlookup function basically also has the function syntax and features like vlookup function, which is to help users find data in excel table, with the conditions or given information. here is the guide for using the hlookup function in detail.
  • How to use the SUM function to calculate totals in ExcelHow to use the SUM function to calculate totals in Excel
    sum is a popular and very useful excel function, and is also a basic arithmetic function. as its name suggests, the sum function is used to calculate totals in excel. and the parameters can be single parameters or ranges of cells. in this article, tipsmake.com will guide you to use the sum function to calculate the sum in excel, the common errors when calculating sum by sum and how to fix it.
  • 6 ways to fix arrow keys not working in Excel6 ways to fix arrow keys not working in Excel
    the arrow keys help you move from cell to cell in an excel spreadsheet with a single keystroke. it can be frustrating when your excel arrow keys aren't working properly.
  • How to Use Function Keys Without Pressing Fn on Windows 10How to Use Function Keys Without Pressing Fn on Windows 10
    you may be a bit annoyed because you have to press the fn key over and over to use the f1 to f12 keys on the keyboard. fortunately, there are a few ways to change this. tipsmake today will show you how to use function keys (f1 to f12) without pressing the fn key on windows 10. note: some computer manufacturers have preset the fn key used to activate the icon thumbnails on the keys f1 to f12 instead of pressing the key in that sequence directly; check in your computer's manual or try pressing the function keys to see if the fn key is needed before continuing.
  • How to use the WORKDAY function in Microsoft ExcelHow to use the WORKDAY function in Microsoft Excel
    in microsoft excel, the workday function is a function that deals with a date and time, and its purpose is to return the date before and after the specified number of working days.
  • Summary of the features of Fn keys on laptopsSummary of the features of Fn keys on laptops
    the fn key on the laptop keyboard with the full name is function. we still often call the function key. keys are often used in combination with keys f1 => f12. some new laptop lines often incorporate some other keys.
  • Difference between function and formula in ExcelDifference between function and formula in Excel
    one of the core features of excel is the ability to perform calculations using functions and formulas. although these terms are often used interchangeably, they have distinct meanings.
  • How to use the LEN function in ExcelHow to use the LEN function in Excel
    the len function in excel is used to measure the length of a certain string of characters, including spaces and correctly return the total character for the user.
  • How to use the IF function in ExcelHow to use the IF function in Excel
    the if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value