Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 70 - 2610_Springdales_C-5
P. 70

    Selecting a Column

                  To select a column, place the mouse pointer on the
                  column header of the column. Click on the column

                  header, the entire column gets selected.

                                                              Selecting a Range of Cells

                                                              A range is a rectangular section of cells which are next
                                                              to each other and at least one side of their border is

                                                              common. A range is defined by the cell addresses of
                                                              the top left cell and the bottom right cell with a colon (:)
                                                              in between. For example, the range address is B2:D10.
                                                              B2 is the address of the top left cell. D10 is the address
                                                              of the bottom right cell.

                  To edit the contents in a range of cells, you have to select the range.

                  Using the Mouse

                  To select a range of cells using a mouse: First click in the
                  top left cell and drag to the bottom right cell. The range gets
                  selected. All the selected cells get highlighted. Only the active
                  cell is not highlighted.

                  Using the Keyboard

                  You can also select a range by clicking the top left cell. Then
                  keeping the Shift key pressed while using the arrow keys to
                  reach the bottom right cell of the desired range. The range
                  will be selected.

                                                    Selecting Multiple Cells

                                                    To select a group  of cells which  are not  next  to each other,
                                                    click on the  first cell. Now, keeping  the  Ctrl key pressed,
                                                    click  on  the other cells to  select. All  the  selected  cells will  be

                                                    highlighted.

                                     What if you could use Excel to track the books you’ve read and the books you want to
                                     read? How would you rate them and what genres would you include?

                            Premium Edition-V
                     68

| 65 66 67 68 69 70 71 72 73 74 75 |