Page 69 - TrackpadV1.0_C5_Flipbook
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  +  Alt    +

                 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:








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