Ctrl+F10: Maximize or restores the selected workbook window.Key tips display shortcut letters on menus that you can press to navigate menus and activate commands. Ctrl+Alt+Shift+ F9: Recheck dependent formulas and then calculate all cells in all open workbooks.Ctrl+Alt+F9: Calculate all formulas on all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.Shift+F9: Perform calculations on the active worksheet.Refreshing the workbook performs new calculations on all formulas. While in this mode you can use arrow keys or your mouse to add non-adjacent cells to your currently selected cells. Shift+F8: Turn the “Add to Selection” mode on and off.While in this mode, you can use your arrow keys to extend or reduce the current selection of cells. F8: Turn the extend selection mode on and off.If you have a word selected when you press this combo, Excel opens the thesaurus and looks up the selected word. F7: Perform spell check in the selected range.Ctrl+Shift+F6: Switch to the previous workbook window when you have more than one workbook window open.Ctrl+F6: Switch to the next workbook window when you have more than one workbook window open.
In a worksheet that has been split, this combo moves you to the previous pane. Shift+F6: Move in reverse order between the Ribbon, worksheet, tabs, and status bar.In a worksheet that has been split, this combo moves you to the next pane. F6: Move between the Ribbon, worksheet, tabs, and status bar.Ctrl+F5: Restore the window size of the active workbook window.Shift+F5: Open the Find And Replace window.F5: Open the Go To window where you can jump to a named range or address.This closes all open workbooks (giving you the chance to save changes first) and exits the program. Ctrl+F4: Close the current workbook. You’ll be asked to save the document if you’ve made any changes.Ctrl+Shift+F4: Work the same as Shift+F4 but works toward the beginning of the document.This one’s handy because you can use it to browse search results without having the Find and Replace window open. Shift+F4: Repeat the last find action.If you have a cell reference or range selected when you hit F4, Excel cycles through available references. Ctrl+Shift+F3: Open the Create Names From Selection window, which lets you create new names using selected rows and columns.Shift+F3: Open function insert dialog box.Ctrl+F3: Open the name manager dialog box so you can create and edit defined names.F3: Open the Paste Name window if you have defined names in the workbook.Alt+Shift+F2: Save the current workbook.
Shift+F2: Allow you to insert or edit comments on selected cells.Ctrl+F2: Open the Print window, where you can preview and print your document.If editing is disabled for a cell, this combo moves your insertion point into the formula bar instead. F2: Turn on editing in the cell and places your insertion point at the end of the cell’s data.Alt+F1: Create an embedded chart from data in the currently selected range.This gives you something like a full-page view of your sheet. Ctrl+Shift+F1: Hide and unhide the Excel Ribbon, the title bar, and the status bar at the bottom of the window.
This is the case most of the time when you press F1 while a dialog box is open. Sometimes, though, pressing F1 takes you to Microsoft’s support site and shows you more targeted articles about the feature you’re looking at.