Page 57 - 2422_C5_Flipbook
P. 57

CHANGING THE ACTIVE CELL


                 To change the active cell in a worksheet, you can either use the keyboard or the mouse pointer.
                 When working with a mouse, just click on the cell you want to make active. Given below are
                 the keys and their functions to change the active cell in a worksheet.

                 Key                        Function
                 Enter key                  Moves the active cell one row down

                 Shift + Enter key          Moves the active cell one row up
                 Shift + Tab key            Moves the active cell one column to the left

                 Tab key                    Moves the active cell one column to the right

                 [left arrow key]          Moves the active cell one column to the left
                  [right arrow key]        Moves the active cell one column to the right

                  [up arrow key]           Moves the active cell one row up

                  [down arrow key]         Moves the active cell one row down
                 Ctrl + Home key            Moves the active cell to the first cell i.e. A1

                 Ctrl + End key             Moves the active cell to the last used cell on the worksheet

                        CREATING A NEW WORKBOOK


                 To create  a new workbook,  when the  Excel application  is
                 already running, follow the given steps:                              1

                 Step 1:  Click on File tab. The backstage view appears.
                 Step 2:   Click on New in the left pane. A new pane appears on
                         the backstage view.

                 Step 3:  Click on Blank workbook.
                                                              2



                                  Tech Hint

                                To open a new                                                              3
                              workbook: Ctrl + N







                        ENTERING DATA

                 To enter data in a worksheet, follow the given steps:

                 Step 1:   Click on the cell where you want to enter the data.


                                                                                          Introduction to Excel 2016  55
   52   53   54   55   56   57   58   59   60   61   62