Microsoft Office Tutorials and References
In Depth Information
Understanding Cells and Ranges
When you select a range, the cells appear highlighted. The exception is the active cell,
which remains its normal color. Figure 14.12 shows an example of a selected range (B5:C8)
in a worksheet. Cell B5, the active cell, is selected but not highlighted.
When you select a range, it appears highlighted, but the active cell within the range
is not highlighted.
You can select a range in several ways:
Press the left mouse button and drag, highlighting the range. Then release the
mouse button. If you drag to the end of the window, the worksheet will scroll.
Press the Shift key while you use the arrow keys to select a range.
Press F8 and then move the cell pointer with the arrow keys to highlight the
range. Press F8 again to return the navigation keys to normal movement.
Type the cell or range address into the Name box (located to the left of the
Formula bar) and press Enter. Excel selects the cell or range that you speciﬁ ed.
Go To (or press F5) and enter a range’s
address manually in the Go To dialog box. When you click OK, Excel selects the
cells in the range that you speciﬁ ed.
Find & Select
While you’re selecting a range, Excel displays the number of rows and columns in your selection in the Name box. As
soon as you i nish the selection, the Name box reverts to showing the address of the active cell.