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

