G Guest Sep 15, 2005 #1 Older version of Excel had Synchronous Scrolling or Compare Side by Side. I can't seem to find it in my new Office XP version.
Older version of Excel had Synchronous Scrolling or Compare Side by Side. I can't seem to find it in my new Office XP version.
C Chip Pearson Sep 15, 2005 #2 I'm not familiar with the tool you describe. Perhaps you could add a new window from the Window menu, and arrange them side by side. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
I'm not familiar with the tool you describe. Perhaps you could add a new window from the Window menu, and arrange them side by side. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
D Dave Peterson Sep 16, 2005 #3 xl2003 did add Window|compare side by side (when you have multiple windows visible). And are you sure you're not remembering Lotus 123? I don't recall anything built into the user interface that would do this. This kind of macro worked for me in xl2003 if both windows were showing the same worksheet: Option Explicit Sub SyncWindows() Windows.Arrange ActiveWorkbook:=True, _ synchorizontal:=True, syncvertical:=True End Sub
xl2003 did add Window|compare side by side (when you have multiple windows visible). And are you sure you're not remembering Lotus 123? I don't recall anything built into the user interface that would do this. This kind of macro worked for me in xl2003 if both windows were showing the same worksheet: Option Explicit Sub SyncWindows() Windows.Arrange ActiveWorkbook:=True, _ synchorizontal:=True, syncvertical:=True End Sub
