Page 30 - ModularV1.1 _c6_flipbook
P. 30

04                EDITING IN MS EXCEL



















                              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
                                       Autofill                                 Customise Worksheet Tab



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

                      SELECTING CELLS IN A WORKSHEET
                  Apart from entering data into a worksheet, MS Excel 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. MS Excel allows
                  us to select a single cell or 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 and then press and hold the
                     Shift key down, and click on the last cell up to which we want to make the 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

                  MS Excel provides two ways to modify or change the content of a cell. One is editing the content
                  in Edit mode and the other is overwriting or replacing the entire content of the cell directly. To
                  activate the Edit mode and change the content of a cell, follows these steps:
                  Step 1  Create a new workbook and enter some data into the worksheet similar to the data given
                          below.


                  28      Modular (Ver. 1.1)-VII
   25   26   27   28   29   30   31   32   33   34   35