When in the formula bar, move the cursor to the end of the text Shift-PgDn / Shift-PgUp or Shift-Fn-down arrow / Shift-Fn-up arrowĮxtend selection to the beginning of a rowĮxtend selection to the beginning of the worksheetĬontrol-Shift-Home or Control-Shift-Fn-left arrowįinish entering data in a cell and move to the next cell down / up If more than one worksheet is open, switch to the next one Switch between the worksheet, the Ribbon, the task pane, and Zoom controls Move to the word to the right while in a cell Move to the word to the left while in a cell Move to the last cell that has content in it Move one worksheet tab to the left / rightĬontrol-Page Down / Control-Page Up or Option-right arrow / Option-Left arrow Option-Page Up / Option-Page Down or Fn-Option-up arrow / Fn-Option-down arrow Page Up / Page Down or Fn-down arrow / Fn-up arrow Spell-check the active worksheet or selected range Useful Excel keyboard shortcuts Source: Microsoft Action Note: On Macs, the ⌘ key is the same as the Command or Cmd key. For even more shortcuts, see Microsoft’s Office site.
Most work whether you’re using a subscription (Microsoft 365/Office 365) or non-subscription version of Excel. We’ve listed the shortcuts we’ve found the most useful below.
0 kommentar(er)
