View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default How do I create multiple scroll bars within one Excel sheet?

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
...