Thread: 2nd split
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 2nd split

I'm not familiar with the registry hack you are thinking about then.
However, it seems a simple horizontal split coupled with a New Window view
as 'bj' points out in elsewhere in this thread might meet your needs without
having to mess around in the registry.

Rick


"Kevin" wrote in message
...
Rick,

Thanks for your response.

Is that what you were referring to?


No, I think what I saw was a registry hack that would allow 2 vertical
split bars or 2 horizontal split bars. Creating a 3 pane window.

-Kevin



"Rick Rothstein (MVP - VB)" wrote in
message ...
I thought I remembered seeing a hack somewhere which described a
way to add a 2nd split bar to a worksheet.


You can divide your spreadsheet into 4 scrollable regions, although each
section is not totally independently scrollable. To do a quad-split, do
the following...

1) At the top of the vertical scroll bar, there is a small rectangle (it
almost looks like a min-button)... click and drag it down to the middle
area of the grid. Your spreadsheet should now be in two scrollable
sections.

2) At the right side of the horizontal scroll bar is a similar looking
rectangle... click and drag it to the middle of the grid. Your
spreadsheet will now have four scrollable regions.

Is that what you were referring to?

Rick