Microsoft Office Tutorials and References
In Depth Information
Now try selecting the nonadjacent range A1:A5;G1:G5.
To select the nonadjacent range A1:A5;G1:G5:
1. Select the range A1:A5 , press and hold the Ctrl key, select the range G1:G5 , and then release
the mouse button and the Ctrl key. See Figure 1-22 for the selected nonadjacent range.
Selecting the nonadjacent range A1:A5;G1:G5
2. Click any cell in the worksheet to deselect the range.
Other Selection Techniques
You can also select large cell ranges that extend beyond the borders of the workbook win-
dow. When this situation occurs, Excel automatically scrolls the workbook window hori-
zontally or vertically to display additional cells in the worksheet. Selecting a large cell
range using the mouse drag technique can be slow and frustrating. For this reason, Excel
provides keyboard shortcuts that enable you to quickly select large blocks of data without
having to drag through the worksheet to select the necessary cells. Figure 1-23 describes
some of these selection techniques.
Other range selection techniques
A large range of cells
Click the first cell in the range, press and hold down the Shift key,
and then click the last cell in the range. All of the cells between the
first and last cell are selected.
All cells on the worksheet
Click the Select All button, the gray rectangle in the upper-left
corner of the worksheet where the row and column headings meet.
All cells in an entire row or column
Click the row or column heading.
A range of cells containing data
Click the cell where you want to begin the selection of the range,
press and hold down the Shift key, and then double-click the side of
the cell in the direction that you want to extend the selection. Excel
selects all adjacent cells that contain data, extending the selection
of the range to the first empty cell.