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.
- Summary of expensive shortcuts in Microsoft Excel
How to use function keys in Microsoft Excel
- F1 key
- F2 key
- F3 key
- F4 key
- F5 key
- F6 key
- F7 key
- F8 key
- F9 key
- F10 key
- F11 key
F1 key
- 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.
- Ctrl + F1 : Hide and unhide Excel Ribbon.
- Ctrl + Shift + F1 : Hide and unhide Excel Ribbon, title bar and status bar at the bottom of the window to display the entire sheet.
- Alt + F1 : Create an embedded chart from data in the selected range.
- Alt + Shift + F1 : Create a new sheet.
F2 key
- 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.
- Ctrl + F2 : Open the Print window to preview and print documents.
- Shift + F2 : Allows you to insert or edit comments on the selected cells.
- Alt + Shift + F2 : Save the current workbook.
F3 key
- F3 : Open the Paste Name window if you have named the workbook.
- Ctrl + F3 : Open the name manager dialog to create and edit the set name.
- Shift + F3 : Open the function insert dialog.
- Ctrl + Shift + F3 : Open the Create Names From Selection window to create a new name using the selected rows and columns.
F4 key
- 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.
- Shift + F4 : Repeat the last search, convenient to find search results without opening the Find and Replace window.
- Ctrl + Shift + F4 : This key combination has the same function as Shift + F4 but repeats the first search action.
- Ctrl + F4 : Close the current workbook, a save message will appear if you have made any changes on the workbook.
- Alt + F4 : Exit Microsoft Excel. This will close all workbooks (save changes without pressing Crtl + S ) and exit the program.
F5 key
- F5 : Open the Go To window , move to a range or named address.
- Shift + F5 : Open the Find and Replace window.
- Ctrl + F5 : Restore the size of the active workbook window.
F6 key
- F6 : Move between Ribbon, sheet, tab and status bar.
- Shift + F6 : Move in reverse order between Ribbon, sheet, tab and status bar.
- Ctrl + F6 : Switch to the next workbook window when you open multiple workbook windows.
- Ctrl + Shift + F6 : Switch to the previous workbook window when you open multiple workbook windows.
F7 key
- F7 : Perform a spell check in the selected range.
- 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
- 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.
- 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.
- Alt + F8 : Displays the Excel Excel dialog box.
F9 key
- F9 : Refresh the workbook, this operation performs new calculations on all formulas.
- Shift + F9 : Perform calculations on the active worksheet.
- Ctrl + Alt + F9 : Calculate all formulas on all worksheets in all open workbooks.
- Ctrl + Alt + Shift + F9 : Check the formulas and then calculate all cells in all open workbooks.
F10 key
- F10 : Turn on or turn off key tips. Key tips display letters on menus that you can press to navigate menus and activate commands.
- Shift + F10 : Display context menu, similar to right click.
- Ctrl + F10 : Zoom in or restore the selected workbook window.
- Alt + F10 : Enlarge the program window.
- 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
- F11 : Create a chart for the data selected in a separate chart sheet.
- Shift + F11 : Create a new sheet.
- Alt + F11 : Switch between the Visual Basic Editor and the active workbook.
- Alt + Shift + F11 : Open Microsoft Script Editor.
F12 key
- F12 : Open the Save As window.
- Shift + F12 : Save the current workbook.
- Ctrl + F12 : Open the Open window.
- Ctrl + Shift + F12 : Open the Print window.
See more:
- Learn the functions of F1 - F12 keys on Windows operating system
- List of common shortcuts for Google Sheets on computers (Part 1)
- More than 60 Windows shortcuts you should memorize
4 ★ | 1 Vote
You should read it
- How to use the SUM function to calculate totals in Excel
- How to use the LEN function in Excel
- How to use the MOD function and QUOTIENT function in Excel
- How to fix the SUM function doesn't add up in Excel
- How to use COUNTIF function on Excel
- How to use MID functions to get strings in Excel
- How to use Excel's VALUE function
- How to use the WRAPROWS function in Excel
May be interested
- How to use the FILTER function in Excelif 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 Excelhlookup 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 Excelsum 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 Excelthe 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 10you 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 Excelin 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 laptopsthe 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 Excelone 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 Excelthe 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 Excelthe 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