Page 57 - TP_Prime_v2.2_Class_5
P. 57
Selecting a Row
To select a row, follow these steps:
Step 1: Place the mouse pointer on the row header of the row to be selected. The
mouse pointer will change to an arrow.
Step 2: Click on the row header, the entire row gets selected.
Selecting a Column INTRODUCTION TO EXCEL 2016
To select a column, follow these steps:
Step 1: Place the mouse pointer on the column header of the column to be selected.
The mouse pointer will change to an arrow.
Step 2: Click on the column header, the entire column gets selected.
Selecting a Range of Cells
55
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 Keyboard
You can also select a range by clicking the top left cell. Then keeping the Shift key
pressed, click on the diagonally opposite bottom right cell. 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.

