Shift+F8: Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.Ĭtrl+F8: Performs the Size command when a workbook is not maximized.Īlt+F8: Displays the Macro dialog box to create, run, edit, or delete a macro.į9: Calculates all worksheets in all open workbooks.

In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel.į8: Turns extend mode on or off. Shift+F6: Switches between the worksheet, Zoom controls, task pane, and ribbon.Ĭtrl+F6: Switches to the next workbook window when more than one workbook window is open.į7: Opens the Spelling dialog box to check spelling in the active worksheet or selected range.Ĭtrl+F7: Performs the Move command on the workbook window when it is not maximized.

In a worksheet that has been split, F6 includes the split panes when switching between panes and the ribbon area. Shift+F3: Displays the Insert Function dialog box.Ĭtrl+F5: Restores the window size of the selected workbook window.į6: Switches between the worksheet, ribbon, task pane, and Zoom controls. Available only if names have been defined in the workbook. If editing a formula, it toggles Point mode off or on so you can use arrow keys to create a reference.Ĭtrl+F2: Displays the print preview area on the Print tab in the Backstage view.į3: Displays the Paste Name dialog box. Or, if editing is turned off for the cell, move the insertion point into the formula bar. KeyĪlt+F1: Creates an embedded chart of the data in the current range.į2: Edit the active cell and put the insertion point at the end of its contents. Some standalone while others if you combine with Ctrl or Alt or shift or a combination of those keys do more. This tip follows on from previous lists of keyboard shortcuts in General, Formatting, Navigation, Data Functions as well as Referencing and Selecting. Some, not all, are useful to learn.

I have put together a list of function key uses. This seems to be common across all software. If you’re a gamer then you probably know the F1 key as Help. In all my years of training I am always stunned that most people don’t even know that there are keys at the top of their keyboard that are called function keys.

How to remove excel shortcut keys