Page 74 - Trackpad_V2.1_Class5
P. 74

In the previous chapter, we learnt how to open Excel, how to enter data, and how to select
                  it, and also learnt 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  +  Alt    +
                  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               Click here to select

                  row to be selected. The mouse pointer will change to an arrow. Now                 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.
                  We can select a range of cells with the help of:








                   72   Trackpad (V2.1)-V
   69   70   71   72   73   74   75   76   77   78   79