• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Managing the Worksheet Displ... > Viewing a Window Through Multiple Pa...

Viewing a Window Through Multiple Panes

Dividing an Excel window into sections enables you to see two or four parts of a worksheet. Appropriately, each section of the window is referred to as a pane. Multiple panes are particularly useful when you work with databases or large worksheets. When you split the screen vertically, the two panes can be scrolled independently in the horizontal direction. Vertical scrolling is synchronized, and there is only one vertical scroll bar for both panes. Horizontal panes work just the opposite. They scroll independently in the vertical direction and are synchronized in the horizontal direction.

As an illustration, you can display both the list and criteria range for an Advanced Filter at the same time even if they are many rows apart. In Figure 20.9 the criteria range and the viewed portion of the list are over 260 rows apart. The multiple pane technique enables you to enter a criterion in one pane and see the resulting filtered data in the other pane.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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