|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 17th, 2009, 05:24 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get synchronized windows?
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. 
|
|
#2
May 17th, 2009, 05:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get synchronized windows?
In 2007 View--Window--Split
-- If this post helps click Yes --------------- Jacob Skaria "harry46" wrote: 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.
|
|
#3
May 17th, 2009, 06:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get synchronized windows?
In 2003 WindowNew window followed by WindowArrangeHorizontal
If this post helps click Yes --------------- Jacob Skaria "harry46" wrote: 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.
|
|
#4
May 17th, 2009, 07:46 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get synchronized windows?
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" wrote in message ... 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.
|
|
#5
May 18th, 2009, 10:13 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get synchronized windows?
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. "Homey" wrote: 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" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
