Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.Ĭreates a chart (on a separate chart sheet) using the highlighted range as the data source.ĭisplays the Insert Function dialog box (can be used from the formula bar). Replaces the highlighted part of a formula with its result to help debug when using the formula bar.

(only cells containing formulas that have changed since the last calculation will be updated). Calculates All the worksheets in All the open workbooks.

You will see the text 'Extend Selection' appear in the status bar. Toggles whether to extend a selection with the arrow keys. Moves to the next item (worksheet, ribbon, task pane). When you are editing a cell this toggles between relative, absolute and mixed cell references. When you are not editing a cell this repeats the last command or action. This dialog box is only displayed if the active workbook contains at least one named range. If this option is not checked the cursor will move to the Formula Bar.ĭisplays the Paste Name dialog box.

(Advanced, Editing options - allow editing directly in cells). This is only available when the following option is ticked. This is a complete list of all the shortcut keys in Excel.Īllows you to edit the active cell directly, putting the cursor at the end.

Windows excel shortcut keys