Page 115 - TP-Play_V-2.0_Book-7
P. 115

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)     115
   110   111   112   113   114   115   116