Page 75 - 2620_Birla Open Mind C-5

Selecting a Range of Cells

A range is a collection of selected cells. It 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. Selection of a range of

cells is done by -

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 visible as highlighted.

Using the 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 multiple 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.

Selecting the Whole Worksheet

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

Hintbot

To select the entire
worksheet: Ctrl + A

#Editing Cell Contents in Excel 2019 73