Excel 2016 Keyboard Shortcuts Cheatsheet

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. 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).

Navigate in Cells contd... Select the entire work-sheet. Select the current and next sheet in a workbook. Select the current and pre-vious sheet in a workbook.

Loading..

Tags:

  2016, Excel, Shortcut, Keyboard, Cheatsheet, Excel 2016 keyboard shortcuts cheatsheet

Information

Related search queries