![]() 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 ke圜trl+arrow keyEnd, arrow ke圜trl+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. Enter End mode, move toġ 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. Move to the edge of the current data region in a worksheet. 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).Įxcel 2016 Keyboard Shortcuts Cheatsheet Move to the previous cell in a worksheet or the previous option in a dialog box. Example: barber Search Excel 2016 Keyboard Shortcuts CheatsheetĬlose 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |