View Two Parts Of A Worksheet Simultaneously
If you need to view or work with different parts of your worksheet at the same time, you can, by using Excel's split screen feature. Splitting the screen allows you to split a worksheet into two separate panes, either vertically or horizontally, that can be scrolled separately.
First, locate the two split boxes. One is the small box immediately above the vertical scroll bar arrow and the other is immediately to the right of the horizontal scroll bar arrow. When you position the mouse pointed over the split box, the pointer will change to a two-headed arrow.
To split the screen horizontally: