Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 65 - 2620_Birla Open Mind C-5
P. 65

    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  63

| 60 61 62 63 64 65 66 67 68 69 70 |