Move one cell left in a worksheet. Left Arrow key Move one cell right in a worksheet. Right Arrow key Move to the edge of the current data region in a worksheet. Ctrl+Arrow key Enter End mode, move to the next nonblank cell in the same column or row as End, Arrow key the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column. Move to the last cell on a worksheet, to the lowest used row of the rightmost Ctrl+End used column. Extend the selection of cells to the last used cell on the worksheet (lower-right Ctrl+Shift+End corner). Move to the cell in the upper-left corner of the window when Scroll Lock is Home+Scroll turned on. Lock Move to the beginning of a row in a worksheet. Home Move to the beginning Ctrl+Home of a worksheet. Move one screen down in a worksheet. Page Down Move to the next sheet in a workbook. Ctrl+Page Down Move one screen to the right in a worksheet. Alt+Page Down Move one screen up in a worksheet. Page Up Move one screen to the left in a worksheet. Alt+Page Up Move to the previous sheet in a workbook. Ctrl+Page Up Move one cell to the right in a worksheet. Or, in a protected worksheet, move Tab between unlocked cells. Format in cells: keyboard shortcuts To do this Press Format a cell by using the Format Cells dialog box. Ctrl+1 Format fonts in the Format Cells dialog box. Ctrl+Shift+F or Ctrl+Shift+P Edit the active cell and put the insertion point at the end of its F2 contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. Add or edit a cell comment. Shift+F2 Insert blank cells with the Insert dialog box. Ctrl+Shift+Plus (+) Display the Delete dialog box to delete selected cells. Ctrl+Minus (-) Enter the current time. Ctrl+Shift+colon (:) Enter the current date. Ctrl+semi-colon (;)
Move one cell left in a worksheet. Left Arrow key Move one cell right in a worksheet. Right Arrow key Move to the edge of the current data region in a worksheet. Ctrl+Arrow key Enter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column. End, Arrow key Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. Ctrl+End Extend the selection of cells to the last used cell on the worksheet (lower-right corner). Ctrl+Shift+End Move to the cell in the upper-left corner of the window when Scroll Lock is turned on. Home+Scroll Lock Move to the beginning of a row in a worksheet. Home Move to the beginning of a worksheet. Ctrl+Home Move one screen down in a worksheet. Page Down Move to the next sheet in a workbook. Ctrl+Page Down Move one screen to the right in a worksheet. Alt+Page Down Move one screen up in a worksheet. Page Up Move one screen to the left in a worksheet. Alt+Page Up Move to the previous sheet in a workbook. Ctrl+Page Up Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells. Tab Format in cells: keyboard shortcuts To do this Press Format a cell by using the Format Cells dialog box. Ctrl+1 Format fonts in the Format Cells dialog box. Ctrl+Shift+F or Ctrl+Shift+P Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. F2 Add or edit a cell comment. Shift+F2 Insert blank cells with the Insert dialog box. Ctrl+Shift+Plus (+) Display the Delete dialog box to delete selected cells. Ctrl+Minus (-) Enter the current time. Ctrl+Shift+colon (:) Enter the current date. Ctrl+semi-colon (;)
Excel%202016%20for%20Windows%20keyboard%20shortcuts.docx