Excel 2016 Keyboard Shortcuts Cheatsheet

1 Close a spreadsheetOpen a spreadsheetGo to the Home tabSave a spreadsheetCopyPasteUndoRemove cell contentsChoose a fill colorCutGo to Insert tabBoldCenter align cell contentsGo to Page Layout tabGo to Data tabGo to View tabFormat a cell from context menuAdd bordersDelete columnGo to Formula tabCtrl+WCtrl+OAlt+HCtrl+SCtrl+CCtrl+VCt rl+ZDelete keyAlt+H, HCtrl+XAlt+NCtrl+BAlt+H, A, then CAlt+PAlt+AAlt+WShift+F10 Alt+H, BAlt+H,D, then CAlt+MExcel 2016 Keyboard Shortcuts CheatsheetMove to the previous cell in a worksheet or the previous option in a dialog one cell up in a one cell down in a one cell left in a one cell right in a to the edge of the current data region in a End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode.

2 If the cells are blank, move to the last cell in the row or to the last cell on a worksheet, to the lowest used row of the rightmost used the selection of cells to the last used cell on the worksheet (low-er-right corner).Shift+TabUp Arrow keyDown Arrow keyLeft Arrow keyRight Arrow keyCtrl+arrow keyEnd, arrow keyCtrl+EndCtrl+Shift+EndFrequently Used ShortcutsNavigate in CellsNavigate in Cells the entire the current and next sheet in a the current and pre-vious sheet in a the selection of cells by one the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank extend mode on and use the arrow keys to extend a selection. Press again to turn off. Add a non-adjacent cell or range to a selection of cells by using the arrow a new line in the same the selected cell range with the current a cell entry and select the cell an entire column in a an entire row in a +A or Ctrl+Shift+SpacebarCtrl+Shift+Page DownCtrl+Shift+Page UpShift+arrow keyCtrl+Shift+arrow keyTurn extend mode on and use the arrow keys to extend a selection.

3 Press again to turn off. F8 Shift+F8 Alt+EnterCtrl+EnterShift+EnterCtrl+Space barShift+SpacebarMake Selections & Perform ActionsMove to the cell in the upper-left corner of the window when Scroll Lock is turned to the beginning of a row in a worksheet. Home Move to the begin-ning of a one screen down in a to the next sheet in a one screen to the right in a one screen up in a one screen to the left in a to the previous sheet in a one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked +Scroll LockCtrl+HomePage DownCtrl+Page DownAlt+Page DownPage UpAlt+Page UpCtrl+Page UpTabFormat in CellsFormat a cell by using the Format Cells dialog fonts in the Format Cells dialog the active cell and put the insertion point at the end of its contents.

4 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 or edit a cell blank cells with the Insert dialog the Delete dialog box to delete selected the current the current between displaying cell values or formulas in the a formula from the cell above the active cell into the cell or the Formula the selected the selected content at the inser-tion point, replacing any +1 Ctrl+Shift+F or Ctrl+Shift+PF2 Shift+F2 Ctrl+Shift+Plus (+)Ctrl+Minus (-)Ctrl+Shift+colon (:)Ctrl+semi-colon (;)Ctrl+grave accent (`)Ctrl+apostrophe ( )Ctrl+XCtrl+CCtrl+VExtend the selection of cells to the beginning of the the current region if the worksheet contains data.

5 Press a second time to select the current region and its summary rows. Press a third time to select the entire the current region around the active cell or select an entire PivotTable the first command on the menu when a menu or submenu is the last command or action, if the last +Shift+HomeCtrl+A or Ctrl+Shift+SpacebarCtrl+Shift+asterisk (*)HomeCtrl+YCtrl+ZMake Selections & Perform ActionsFormat in Cells content by using the Paste Special dialog text or remove italic text or remove bold text or remove or remove strike-through between hiding objects, displaying objects, and displaying placehold-ers for an outline border to the selected the outline border from the selected or hide the outline the selected the selected the Fill Down com-mand to copy the contents and format of the topmost cell of a selected range into the cells the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the +Alt+VCtrl+I or Ctrl+3 Ctrl+B or Ctrl+2 Ctrl+U or Ctrl+4 Ctrl+5 Ctrl+6 Ctrl+Shift+amper-sand (&)Ctrl+Shift+underline (_)

6 Ctrl+8 Ctrl+9 Ctrl+0 Ctrl+DCtrl+RFormat in Cells the General number the Currency format with two decimal places (negative numbers in pa-rentheses).Apply the Percentage format with no decimal the Scientific num-ber format with two deci-mal the Date format with the day, month, and the Time format with the hour and minute, and AM or the Number format with two decimal places, thousands separator, and minus sign (-) for negative or edit a spelling in the active worksheet or selected the Quick Analysis options for selected cells that contain the Create Table dialog +Shift+tilde (~)Ctrl+Shift+dollar sign ($)Ctrl+Shift+percent (%)Ctrl+Shift+caret (^)Ctrl+Shift+number sign (#)Ctrl+Shift+at sign (@)Ctrl+Shift+exclama-tion point (!)Ctrl+KF7 Ctrl+QCtrl+L or Ctrl+TSelect an entire PivotTable the active cell and put the insertion point at the end of its contents.

7 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 or collapse the formula an entry in the cell or Formula an entry in the formula bar and select the cell the cursor to the end of the text when in the formula all text in the for-mula bar from the cursor position to the all worksheets in all open the active all worksheets in all open workbooks, regardless of whether they have changed since the last +Shift+asterisk (*)F2 Ctrl+Shift+UEscEnterCtrl+EndCtrl+Shift+E ndF9 Shift+F9 Ctrl+Alt+F9 Work with Data, Functions & the Formula barCheck dependent formu-las, and then calculate all cells in all open workbooks, including cells not marked as needing to be the menu or mes-sage for an Error Checking the Function Ar-guments dialog box when the insertion point is to the right of a function name in a argument names and parentheses when the insertion point is to the right of a function name in a Flash Fill to auto-matically recognize pat-terns in adjacent columns and fill the current columnCycle through all combina-tions of absolute and rela-tive references in a formula if a cell reference or range is a the value from the cell above the active cell into the cell or the formula +Alt+Shift+F9 Alt+Shift+F10 Ctrl+ACtrl+Shift+ACtrl+EF4 Shift+F3 Ctrl+Shift+straight quotation mark ( )

8 Work with Data, Functions & the Formula bar an embedded chart of the data in the current a chart of the data in the current range in a separate Chart a name to use in a name from the Paste Name dialog box (if names have been defined in the to the first field in the next record of a data , run, edit, or delete a the Microsoft Visual Basic For Applications +F1F11 Alt+M, M, DF3 EnterAlt+F8 Alt+F11 Work with Data, Functions & the Formula bar)