multiple split screen

[Guest]

Is it possible to have multiple split screens?
I work with huge spreadsheets and I constantly need to view different parts
of the spreadsheet at the same time.
Ideally, I'd like to be able to view 3-4 vertical sections (meaning, having
2-3 vertical splits).
My band aid solution is to continuously group and ungroup the sections I
need - but I realize this is not an elegant solution.

Any suggestions.

Thanks,
DSK

 

[Guest]

That's easy. Click Windows, Arrange, New Window. This will open a
second view (or as many as you want) of the same spreadsheet (watch the title
bar of each window and you'll see .1 or .2 behind the name). You navigate
each window independently and can copy/paste at will, across the windows.
Shut each one down when finished.

Steve in Ohio

 

[Guest]

Thanks, Stephen.
This partially solves my viewing problem.
Reason I say partially is that unfortunately the other views don't scroll
simultaneously when I scroll down in one window, for example.
But anyway, it is an improvement to my earlier method.
Cheers,
DSK

 

[Gord Dibben]

DSK

From an earlier post by myself and Dave Peterson.

********************************

Dave/RBS

2003 has a "Compare side by side" feature on the Window menu.

Allows you to synch the windows for scrolling.

Gord

Jim Rech posted this:

http://groups.google.com/groups?selm=eGtL9Sbu$GA.207@cppssbbsa03

It may do what you want (well, if you change it to Trues).

And I think that I've seen posts that this is built into xl2003. (but not sure)


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

**********************************************

Gord Dibben Excel MVP