Page 121 - PlugGPT_V2.0_C7_Flipbook
P. 121
Keyboard Shortcuts
Excel 2016
Shortcut Keys Description
Ctrl+A To select the entire worksheet
Ctrl+N To create a new workbook
Ctrl+O To open an existing workbook
Ctrl+S To save a workbook
F12 To open the Save As dialog box
Ctrl+W To close a workbook
Ctrl+F4 To close MS Excel
F4 To repeat the last command or action
Shift+F11 To insert a new worksheet
F11 To create a bar chart based on selected data
Ctrl+Tab To switch between open workbooks
Ctrl + Right Arrow Key To go to on the last column of the workbook
Ctrl + Down Arrow Key To go on the last row of the workbook
Tab To go to the next cell
Shift+Tab To go to the previous cell
Ctrl+Home To move to the beginning of a worksheet
F2 To edit a cell contents
Shift+Spacebar To select the entire row
Ctrl+Spacebar To select the entire column
Ctrl+C To copy the contents of a cell or a range of selected cells
Ctrl+V To paste the copied contents of a cell
Ctrl+X To cut the contents of a cell
Ctrl+P To print a worksheet
Ctrl+: To insert the current time
Ctrl+; To insert the current date
Alt+= To calculate sum automatically
Keyboard Shortcuts (Excel 2016) 119

