Page 97 - ModularV1.1 _c7_flipbook
P. 97

Keyboard Shortcuts



                                                         MS Excel                                  Computational Thinking



                            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 the last column of the workbook

                     Ctrl + Down Arrow Key          To go to 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 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 the sum automatically


                                                                                              Keyboard Shortcuts  95
   92   93   94   95   96   97   98