Home |
Search |
Today's Posts |
#1
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
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
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
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
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
Gridlines not synchronized horizontally with text | Excel Discussion (Misc queries) | |||
Synchronized combo box in excel form | Excel Worksheet Functions | |||
synchronized windows | Excel Discussion (Misc queries) | |||
How to stop "Synchronized Scrolling" in Excel Workbook comparing | Excel Worksheet Functions |