Page 34 - TP_Modular_V2.1_Class7
P. 34

EDITING IN EXCEL 2016
                    04














                          Your Aim

                          to learn about:

                                  Selecting Cells in a Worksheet           Copying/Moving Data
                                   Using Undo and Redo Features              Column Width and Row Height
                                    Inserting Rows/Columns                     Merging Cells
                                      Auto Fill                                  Customise Worksheet Tab


                  In the previous chapter, we have learned about different components of Excel 2016 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 2016.

                      SELECTING CELLS IN A WORKSHEET

                  Apart  from entering  data  into a worksheet,  Excel 2016 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 2016
                  allows us to select a single cell or a group of cells. To select:
                      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. You can also
                     select a range of cells by using the Shift key. Click on the first cell and then press and hold the
                     Shift key down, and click on the last cell up to which you want to make 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 2016 provides two ways to modify or change the content of a cell. One is editing the

                  content in Edit mode and other is overwriting or replacing the entire content of the cell directly.

                   32       Modular (Ver. 2.1)-VII
   29   30   31   32   33   34   35   36   37   38   39