Microsoft Office Tutorials and References
In Depth Information
Navigating in Worksheets and Workbooks
Navigating in Worksheets and Workbooks
You can plod your way through any worksheet by clicking and typing in individual cells, but
worksheets and formulas become much more powerful when you work with multiple cells
simultaneously. In Excel’s parlance, any selection of two or more cells is a range . You can use
a range as the argument in a formula and to define data series and labels in charts. You can
also enter, edit, and format data in multiple cells simultaneously by selecting a range first.
In a budget worksheet, for example, you can select the range containing totals and apply
the Currency format to all the cells in that range with a single action.
If you click in any cell and drag in any direction, your selection of adjacent cells is called a
contiguous range . As you expand your selection, the Name box provides feedback about
the size of the range. In this example, the current range consists of 11 rows and 4 columns:
Select All
A reference to a contiguous range consists of two cell addresses separated by a colon. The
two addresses identify the upper left and lower right corners of the range, respectively. In
the previous example, the range address is A1:D11. You can also define a noncontiguous
range by holding down the Ctrl key as you select any combination of individual cells and
ranges on a single worksheet. You can apply cell formatting to a contiguous or
noncontiguous range, and you can use either type of range as the argument in a formula.
One related navigational concept is worth noting here as well. Excel defines the current
region as the area around the active cell that is enclosed by blank rows and blank columns.
If you define a table, for example, Excel expands the default selection to include the current
Search JabSto ::

Custom Search