Hi David,
I'm working on an Excel sheet that is broken down to two parts. On one side
of the sheet has info and values and the other side has relative info. The
side with the relative info goes down much farther than the side with the
values. So when I get ready to enter values on the other side I have to
scroll back up to the top. I'd like to insert a verticle scroll bar for the
"values" half of the sheet to keep it aligned with the "relative info" side.

P.S. I'm being asked to rate your response - from where am I supossed to
provide rate info.
"David McRitchie" wrote:

Hi Joe,
Specifically in Excel you have on the window menu of Excel
Freeze and Split they are pretty much the same and are mutually exclusive.
Split will get you a (one) split horizontal and/or vertical and the areas are separately
scrollable. http://www.mvps.org/dmcritchie/excel/freeze.htm

To split both ways Select cell F15 then window, split -- to undo window, remove split
To split just on rows select cell A15 then window, split -- to undo window, remove split
to split just on columns seelct cell F1 then window, spli -- to undo window, remove splitt

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

" wrote in message
...