Page 51 - TP_Play_V2.1_class5
P. 51

EDITING IN EXCEL 2016
                    05














                         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.



                                                                                        Editing in Excel 2016     49
   46   47   48   49   50   51   52   53   54   55   56