| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
| How do I locate the horizontal scroll bar excel 2000? | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
| pivotcell object to excel 2000 | Excel Discussion (Misc queries) | |||
Hybrid Mode
