In Excel 2000, how do I add a vertical scroll bar to a split scre.

L

Lisa_196

When I split my worksheet screen, I get an additional horizontal scroll bar
but not a vertical. How do I rectify this? If it helps, what I am trying to
do is lock two colums so that they don't scroll when other columns do, so
that they always remain visible.
 
G

Gord Dibben

Lisa

Split won't allow that.

Take the Split off and then Window>New Window to get two windows.

Now Window>Arrange>Vertical to get them side by side.

Resize the two column window.

If you tire of this configuation, close one of the windows then save.


Gord Dibben Excel MVP
 
Top