Home / Computers / Microsoft Excel

Working with Ranges

In Excel, you can work with multiple cells at once (called a range). To select a range, click the first cell and, holding down the mouse button, drag the mouse to the last cell. All the cells in the range you defined are selected.

Alternatively, you can select the first cell, hold down the Shift key, and then select the last cell in the range; this selects adjacent cells, as shown in the illustration above. If, instead, you want to select several cells that aren't adjacent, hold down the Ctrl key on your keyboard while you click each cell you want to select.

To quickly select an entire row or column, click the row or column heading, respectively. You can select multiple rows or columns by clicking on the first row or column heading in the range, holding down the mouse button, and dragging to the last row or column heading in the range.

Tip:

To select the entire contents of a worksheet, click the box in the upper left corner of the worksheet, where the first row and first column intersect: