O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required