Page 59 - TP_Plus_v4_Class4
P. 59

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 using keyboard keys.


                 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, follow the given steps:


                                                 1                              2
                            Click on File tab.          Click on New option.




                                                                                                Click on Blank   3
                                                                                                workbook.











                      ENTERING DATA                                                             The text appears in
                                                                                                  the Formula bar
                 To  enter  data  in  a  worksheet  click  on  the  cell
                 where you want to enter the data and start typing
                 your text or numbers.

                 When  you type in Excel, you will see that two

                 buttons become active in the box to the left of
                 the Formula bar.


                                                                                          #Introduction to Excel 2019  57
   54   55   56   57   58   59   60   61   62   63   64