Author: Hayley Milliman / Source: How-To Geek
The function keys on keyboards don’t get the love they used to, but depending on the app you’re running, they can still be quite handy. Microsoft Excel has some interesting features tucked away behind your function keys. Here’s what they do.
F1
- F1: Get help. How this works depends on what you’re looking at in the Excel window. Press F1 in the regular window, for example, to open the Help pane. Sometimes, though, pressing F1 takes you to Microsoft’s support site and shows you more targeted articles about the feature you’re looking at. This is the case most of the time when you press F1 while a dialog box is open.
- Ctrl+F1: Hide and unhide the Excel Ribbon.
- Ctrl+Shift+F1: Hide and unhide the Excel Ribbon, the title bar, and the status bar at the bottom of the window. This gives you something like a full-page view of your sheet.
- Alt+F1: Create an embedded chart from data in the currently selected range.
- Alt+Shift+F1: Create a new worksheet.
F2
- F2: Turn on editing in the cell and places your insertion point at the end of the cell’s data. If editing is disabled for a cell, this combo moves your insertion point into the formula bar instead.
- Ctrl+F2: Open the Print window, where you can preview and print your document.
- Shift+F2: Allow you to insert or edit comments on selected cells.
- Alt+Shift+F2: Save the current workbook.
F3
- F3: Open the Paste Name window if you have defined names in the workbook.
- Ctrl+F3: Open the name manager dialog box so you can create and edit defined names.
- Shift+F3: Open function insert dialog box.
- Ctrl+Shift+F3: Open the Create Names From Selection window, which lets you create new names using selected rows and columns.
F4
- F4: Repeat your last action. If you have a cell reference or range selected when you hit F4, Excel cycles through available references.
- Shift+F4: Repeat the last find action. This one’s handy because you…
The post What Your Function Keys Do In Microsoft Excel appeared first on FeedBox.