Featured Blogs

image
Working with Large Files in Excel

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.

Excel-Large-Files

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.

userMaggie

date29 Dec 2012

Don’t miss the opportunity to develop your job-ready skills, click on Enquire Now button. Hurry!

Request info Get Free Advice Quick Enquiry
LOADING