Page 133 - TP_Play_V2.1_class7
P. 133

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)     131
   128   129   130   131   132   133   134