Microsoft® Excel® 2010 Inside Out

Moving Around Regions

A region is a rectangular range of cell entries, or a block of “filled cells.” In Figure 6-1, the range A3:E7 is a region, as are the ranges G3:H7, A9:E10, and G9:H10. (Strictly speaking, cell A1 is a one-cell region, too.) For example, cell H10 is within a region, even though it’s empty.

The active area of the worksheet is the selection rectangle that encompasses all regions—that is, all the filled cells in the active worksheet—which in Figure 6-1 is A1:H10.

The techniques you can use to navigate regions are helpful if you typically work with large tables of data. Getting to the bottom row of a 500-row table is easier when you don’t have to use the scroll bars.

Figure 6-1. There are four regions—blocks of “filled” cells—on ...