Microsoft Office Tutorials and References
In Depth Information
Selecting with the mouse
Figure 6-4 Select entire columns and rows by clicking their headings, or hold down the Ctrl key
while clicking to select nonadjacent rows and columns.
Use the following methods to select with the keyboard:
To select an entire column with the keyboard, select any cell in the column and press
To select an entire row with the keyboard, select any cell in the row and press
To select several entire adjacent columns or rows with the keyboard, select any cell
range that includes cells in each of the columns or rows and then press Ctrl+Spacebar
or Shift+Spacebar, respectively. For example, to select columns B, C, and D, select
B4:D4 (or any range that includes cells in these three columns) and then press
To select the entire worksheet with the keyboard, press Ctrl+Shift+Spacebar.
If you hold down the Shift key while navigating regions (as described in “Navigating
regions with the keyboard” earlier in this chapter), Excel selects all the cells in between. For
example, if cell A3 was the only cell selected in the worksheet shown in Figure 6-4, holding
the Shift key while pressing Ctrl+Right Arrow would select the range A3:E3, and then, still
holding Shift, pressing Ctrl+Down Arrow would select the range A3:E7.