If you apply both horizontal and vertical split bars, in which four panes are created, only two panes remain stationary when you scroll within one pane. If you apply either a horizontal or vertical split bar, you can scroll within one pane while the other pane remains stationary. Split bars are illustrated in Figure 1-3. When you apply split bars to a worksheet, Excel creates identical copies of the worksheet side by side. You do this by applying either split bars or freezing panes.įor live face-to-face Excel training in Los Angeles call us on 888.815.0604. You might, for example, want to keep the labels in row 4 visible while you scroll down to look at information located in row 35. In many cases, you might find it helpful to work with different sections of your worksheet at the same time.
0 Comments
Leave a Reply. |