Page 121 - modular4.0
P. 121

Chapter Profile
                                         Keyboard Shortcuts



                                                       Excel 2019


                           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

                                                    To copy the contents of a cell or a range of selected
                    Ctrl+C
                                                    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 2019)  119
   116   117   118   119   120   121   122