Page 10 - KEC Khaitan C6 Flipbook
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