Page 69 - Trackpad v5 class 5
P. 69

In the previous chapter, we have learnt how to open Excel, how to enter data, how to
            select it, and also learned about working with worksheets. In this chapter, we will learn

            more about Excel.



                      SELECTING A RANGE OF CELLS

            Let us learn how to select a range of cells.

                                                                                     To select a row:
            SELECTING A CELL

            To select a cell, click on the cell. It will become the active      Short key  Ctrl  +  Shift +
            cell and a green border appears around it. You can also
            use the arrow keys to move to change the active cell.                       Left/Right Arrow


            SELECTING A ROW







                      Click here to select an entire row

            To select a row, place the mouse pointer on the row header of the
            row to be selected. The mouse pointer will change to an arrow. Now              Click here to select
                                                                                               entire Column
            click on the row header and the entire row gets selected.

            SELECTING A COLUMN

            To select a column, place the mouse pointer on the column header
            of the column to be selected. The mouse pointer will change to an
            arrow.  Now  click  on the column header, the entire  column gets

            selected.

            Or
            Press Ctrl + Shift + Up/Down Arrow key on the keyboard.


            RANGE OF CELLS

            We might want to select more than one cell at a time to
            perform a certain task. When we select more than one cell
            at a time, these contiguous (adjoining/connected) cells form
            a range.











                                                                                          Editing in Excel 2021  67
   64   65   66   67   68   69   70   71   72   73   74