Microsoft Office Tutorials and References
In Depth Information
Choosing a Select Group of Cells
✓ To select a range of entire columns or rows, drag through the column
letters or row numbers on the frame surrounding the workbook.
✓ To select more than entire columns or rows that are not right next to
each other (that old noncontiguous stuff, again), press and hold down
the Ctrl key while you click the column letters or row numbers of the
columns or rows that you want to add to the selection.
✓ To select every cell in the worksheet, press Ctrl+A or click the Select All
button, which is the button with the triangle pointing downward on the
diagonal (which reminds me of the corner of a dog-eared book page).
It’s in the upper-left corner of the workbook frame, formed by the
intersection of the row with the column letters and the column with the row
Selecting the cells in a table of data, courtesy of AutoSelect
Excel provides a quick way (called AutoSelect) to select all the cells in a table
of data entered as a solid block. To use AutoSelect, simply follow these steps:
1. Click the first cell of the table to select it.
This is the cell in the table’s upper-left corner.
2. Hold down the Shift key while you double-click the right or bottom
edge of the selected cell with the arrowhead mouse pointer. (See
to select all
cells of the
Double-clicking the bottom edge of the cell causes the cell selection
to expand to the cell in the last row of the first column (as shown in
Figure 3-3). If you double-click the right edge of the cell, the cell
selection expands to the cell in the last column of the first row.