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.