How do I synchronize scroll split window tiles?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two vertical split panes and I want them to scroll together so they
stay lined up. Anyone know how? Thnaks.
 
What version of Excel are you using? In 2002? you can use the command
Window, Compare side by side.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I lock a section of cells in place 1
Vertical Split with separate vertical scrolls? 0
How do I get the horizontal split box back? 5
Split screens 1
Mobile phone texts split into incoming and outgoing messages 0
How do I NOT get synchronous scrolling in multiple panes in Excel 2
Scrolling one pane only in a vertically split worksheet 4
How to view tiled Excel worksheets by locking rows for scrolling . 1

Back
Top