Keyboard shortcuts for navigating in cells To do this Press Move to the previous cell in a worksheet or the previous option in a dialog box. Shift+Tab Move one cell up in a worksheet. Up arrow key Move one cell down in a worksheet. Down arrow key Move one cell left in a work...
Note: UsingOption+ Shift + X escape from the section, as well as Down-arrow from the last cell in the section Create and remove a collapsible section. The shortcut is a toggle. Alt + EnterOption + EnterInsert line break into math or (inline) text ...
Ctrl+C - Copies the selected cells. Ctrl+D - Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Ctrl+End - CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. ...
Copies the selected cells Ctrl + D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below Ctrl + End Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column Ctrl + ⤶ Enter...
Ctrl + D – Fill Down to copy contents and format of the top-most cell in the selected range to cells below. + Utility: 5 Ctrl + R – Fill Right to copy contents and format of the left-most cell in the selected range to cells to the right. > > Utility: 5 Alt > O > E –...
Type in a function name within a cell and then press this keyboard shortcut to insert argument names and parentheses to the right of the function name Ctrl+B Ctrl+2 Apply or remove bold formatting Ctrl+C Copy selected cells, or any other selected object such as a chart ...
General Excel Shortcut Copy selected cellsCtrl+C Create chart in new worksheetF11 Create embedded chartAlt+F1 Cut selected cellsCtrl+X Display find and replaceCtrl+F Display find and replace, replace selectedCtrl+H Display the Paste Special dialog boxCtrl+AltV ...
TAB to get to the desired tab, and then LEFT ARROW, RIGHT ARROW Display the shortcut menu for the selected command. ENTER Move the focus to each command on the Ribbon, forward or backward respectively. TAB, SHIFT+TAB Move down, up, left, or right among the items on the Ribbon, respec...
Clipboard keyboard shortcuts These keyboard shortcuts work when theCopyPasteplugin is enabled. WindowsmacOSActionExcelSheets Ctrl+XCmd+XCut the contents of the selected cells to the system clipboard✓✓ Ctrl+CCmd+CCopy the contents of the selected cells to the system clipboard✓✓ ...
Keyboard ShortcutResult Tab Navigates to the next focusable field or element from top to bottom and left to right. Down Arrow Varies based on context: When moving through the location hierarchy in the Home Page, moves one item downward through the list. In a table, moves to the next row...