• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Moving Around

You already know how to use scroll bars and the Page Up and Page Down keys. There are many other ways to get around, including some unique tricks you'll find only in Excel.

Navigating Regions

A region is a range of cell entries bounded by blank cells or column and row headings. In Figure 5-1, the range A3:E7 is a region, as are the ranges G3:H7, A9:E10, and G9:H10. (Strictly speaking, cell A1 is also a region because there are no adjoining cells containing entries.) For example, cell E7 is within a region, even though it's empty. The active area is a rectangle that encompasses all regions—that is, all the filled cells in the active worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint