Scroll down 2 sheets at sametime

[Dazzawm]

I have a workbook with 2 sheets in. I have arranged them so I can view them at the same, but is there anyway that when I scroll down one of the sheets the other sheet will scroll down at the sametime, rather than having to do both independantly?

 

[Andrew Poulsom]

It's Window|New Window then Window|View Side by Side. Look here:

http://office.microsoft.com/en-us/e...same-time-HP001217043.aspx?pid=CH100648381033

 

[Dazzawm]

When I have them side by side like it says the Synchronous Scrolling option is greyed out?

(Created new username for use at work)!

 

[Andrew Poulsom]

Are you sure that View Side by Side is turned on?

 

[Dazzawm]

Yes they are, for some reason the Synchronous Scrolling is active when they are horizontal?!

 

[Dazzawm]

It is working now, but for some reason only when they are one on top of the other rather than side by side!!