How do I get synchronized windows?

H

harry46

In 1-2-3 you used to be able to force two windows viewing the same sheet but
widely different rows to keep their viewed columns oin step. This facility
still exists at least in Excel 2003 as an inherited relic from an imported
file, but I cannot find out how to set it up in a new spreadsheet. The two
synchronized windows can have independent excel-style splits allowing
further different ranges of rows to be viewed.
 
J

Jacob Skaria

In 2003 Window>New window followed by Window>Arrange>Horizontal

If this post helps click Yes
 
H

Homey

Only way to get old 1-2-3 style window sync (so you see Vsync and HSync in
caption) is with macro:

Windows.Arrange ActiveWorkbook:=True, synchorizontal:=true,
syncvertical:=true

to undo set both to false,
 
H

harry46

Yes, thank you, this does it. Perhaps it would be simpler if the next version
of Excel allowed an arbitrary number of splits in a window.
 
Top