Page 68 - ConceptGP_C5_Fb
P. 68

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


                  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.

                  We can select a range of cells with the help of:








                   66   Premium Edition-V
   63   64   65   66   67   68   69   70   71   72   73