Microsoft Office Tutorials and References
In Depth Information
Excel provides a few helpful features you can use to change the way worksheets are
displayed. You can set up your workspace for specific tasks and then save the same view
settings for the next time you need to perform the same task.
Splitting worksheets into panes
Worksheet panes let you view different areas of your worksheet simultaneously. You can
split any worksheet in a workbook vertically, horizontally, or both vertically and
horizontally and have synchronized scrolling capabilities in each pane. On the worksheet shown in
Figure 6-17, columns B through M and rows 3 through 36 contain data. In Normal view, it’s
impossible to see all the data at the same time.
Figure 6-17 You can scroll to display the totals in column N or row 38, but you won’t be able to
see the headings.
You’ll find the 2014Projections.xlsx file with the other examples on the companion website.
It would be easier to navigate the worksheet in Figure 6-17 if it were split into panes. To
do so, first select the cell where you want the split to happen, then click the View tab on
the ribbon, and click the Split button in the Window group; the window divides into both
vertical and horizontal panes simultaneously, as shown in Figure 6-18. When you rest your
pointer on a split bar, it changes to a double-headed arrow.