Page 35 - modular4.0
P. 35

Chapter Profile
                                                                                         Chapter Profile
                  4                                                                Selecting Cells in a Worksheet

                                                                                    Copying/Moving Data
                                                                                      Using Undo and Redo Features


                                                                                        Column Width and Row Height


                                   Editing in                                            Inserting Rows/Columns
                                                                                           Merging Cells

                                  Excel 2019                                                Autofill
                                                                                              Customise Worksheet Tab









                 In the previous chapter, we have learned about different components of Excel 2019 window such
                 as cell, row, column, formula bar, workbook and worksheet. We have also learnt the process of
                 creating a workbook, entering data into a worksheet and saving a workbook. In this chapter, we will
                 learn more about Excel 2019.

                        SELECTING CELLS IN A WORKSHEET


                 Apart from entering data into a worksheet, Excel 2019 also provides the facility to perform various
                 other operations with data such as modifying, inserting, moving/copying and deleting. To perform
                 all these operations, we first need to select the cell that contains data. Excel 2019 allows us to select
                 a single cell or a group of cells.

                    Single Cell: Click on the cell to select it.
                    Group of Cells or Range: Click on the first cell from where you want to start the selection and
                    drag the mouse diagonally up to the cell to which you want to make selection. We can also select
                    a range of cells by using the Shift key. Click on the first cell, then press and hold the Shift key, and
                    click on the last cell up to which we want to make a selection.
                    Entire Row/Column: Click on the row heading to select the entire row or click on the column
                    heading to select the entire column.

                    Entire Worksheet: Click on the Select All button located below the Name box to select the entire
                    worksheet. Shortcut key to select the entire worksheet is Ctrl + A.
                 Modifying Cell Content

                 Excel 2019 provides two ways to modify or change the content of a cell. One is editing the content
                 in Edit mode and other is replacing the entire content of the cell directly. To activate the Edit mode
                 and change the content of a cell, follow the given steps:




                    1  Double-click on the
                    cell whose content we
                    want to change.
                                             2  Type the data.



                                                                                                 Editing in Excel 2019  33
   30   31   32   33   34   35   36   37   38   39   40