In this post, our Excel trainer Maggie runs through using large files in Excel.
Split Screen and Freezing Panes
In many cases, you might find it helpful to work with different sections of your worksheet at the same time.
For example, you might want to keep the data in row 4 visible while you scroll down to look at information located in row 35. You do this by applying split bars.
If you already know how to use split bars but are struggling with other aspects of Excel, why not try ourAdvanced Excel Training.
Applying Split Bars
When you apply split bars to a worksheet, Excel creates identical copies of the worksheet side by side. If you apply either a horizontal or vertical split bar, you can scroll within one pane while the other pane remains stationary.
Although the Split command can be accessed from the View Menu, you can also manipulate split bars with the mouse using thesplit boxes. You can move between the different panes by simply clicking the pane in which you want to work. Because each pane is a view of the same worksheet, a change in one pane means a change to the worksheet.
The VIEW tab contains the option to SPLIT.However, if you do choose to split using this option, Excel will split the Window at the current location, i.e. the cell you are currently in.You will probably end up with a horizontal and vertical split.
To Split a Window horizontally, place the mouse over the Split Symbol and drag it half way down the vertical scroll bar. To Split a Window vertically, place the mouse over the Split Symbol and drag half way across the horizontal scroll bar.
Maggie
29 Dec 2012