scroll sheet1, sheet2, sheet3 to scroll together

Question

How can I scroll one sheet and have other sheet scroll at the same time?

when I scroll sheet1 to A50, sheeet2 will scroll to the same position, along with sheet3.

Answer 1

In Excel

    Windows.SyncScrollingSideBySide = True

---

Ed Ferrero
www.edferrero.com

Answer 2

I don't know anything about VBA. I threw it into the Dev tab, Visual Basic.

I am not true to how it is done, if that is all it needs. Can you clue me in better?

Answer 3

 

Step1 : Select A50 of sheet1 then select A50 of Sheet2.

Step 2 : Goto View Menu->New Window .

A new window will appear with :2 at end,

Step 2 :  .Now select Arrange All->Horizontal

Step 3 :In View Immediately after Split buton you will find View Side by Side button.Click it

That’s All

First try with 2 window.If you are accustomed with 2 window then go for 3 window.

Answer 4

I am able to select a row and select each tab and the row for each tab will be highlighted. What I want to automate is bringing the selected row to be the top of the sheet for every tab.

I don't understand why you use New Window in View menu. It will duplicate filled cells. There was no :2 at end.

I am using Excel 2007.

Answer 5

Do you want something like a Freeze pane, or do you want both having 3 sheets in separate window holding the Top row?

---

Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

Please vote an answer helpful if they helped. Please mark an answer as an answer when your question is being answered.