How do I get synchronized windows?

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

 

[Jacob Skaria]

In 2007 View-->Window-->Split

 

[Jacob Skaria]

In 2007 View-->Window-->Split

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Jacob Skaria]

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

If this post helps click Yes

 

[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,

 

[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,

 

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

 

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