Page 52 - TP-Play_V-2.0_Book-5
P. 52

EDITING IN EXCEL 2016
              06














                    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                                    Customize 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.

                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.


             52       Play (Ver. 2.0)-V
   47   48   49   50   51   52   53   54   55   56   57