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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrolling one pane only in a vertically split worksheet 4
Horizontal scrolling 2
How to I show the horizontal scroll bar in Excel? 2
how do I change the size of vertical scroll bar 6
How to have Excel worksheet open and see all the corners? 1
Making touchpad's Horizontal Scroll region work in Excel/Word 2007 1
Unremovable horizontal scroll bar on subform 1
Restore bottom scroll bar (Excel 2007) 4

Back
Top