Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 10 - 2615_KEC
P. 10

    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 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:

                      Mouse: Left-click the mouse on one cell and drag it to the last
                      cell.
                                                                                                      Click here to select
                      Keyboard: Move the cursor on the first cell of the range by using the              entire Column
                      Arrow keys. Then, press the Shift key, and while keeping it pressed,
                      use the Arrow keys to select the range of the cells.

                      Mouse + Keyboard: Left-click on the first cell of the range, then press
                      the Shift key. Now, move the cursor to the last cell of the range and
                      left-click again.

                      By typing the cell range in the cell number box:
                      <Address of the 1st cell>:<Address of the last cell>

                      Example: Enter C5:E5 in the cell number box and then press the
                      Enter Key.

                      We can deselect the range of the cells by clicking anywhere on the sheet.

                      SELECTING MULTIPLE CELLS
                      To select a group of cells that 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.

                      SELECTING AN ENTIRE WORKSHEET

                      To select the whole worksheet, click the Select All triangle. This button is present above
                      row 1.

                       8    Premium Edition-VI

| 5 6 7 8 9 10 11 12 13 14 15 |