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

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.

Lisa

Split won't allow that.

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

Now WindowArrangeVertical 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

On Thu, 13 Jan 2005 12:37:03 -0800, "Lisa_196"
wrote:

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.