Excel split screen sync question 1

[djj55]

Hello, In Excel 2002 SP3 I have split the screen vertically. I would like to scroll one side without scrolling the other. Is this possible? I do not want freeze pane as it does not give the desired effect.

Thank you,
djj

 

[AnotherHiggins]

At the bottom of the screen, you should see that each of the two sides has its own horizontal scroll bar. Use either of these to scroll the corresponding section.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[djj55]

Sorry, I meant I want to scroll vertically. I am trying to compare two lists one long and one short.

Thank you for your reply,
djj

 

[AnotherHiggins]

oooOOOOhhhh. I see.

I'm pretty sure you can't do that within a single sheet.

But here's an idea:

-right click on the sheet tab
-Select Move or copy
-In the To book dropdown, select new book
- Check the box beside Create a copy
- Click OK

- Now go to Window > Arrange
- Select Vertical
- Click OK

Now you have two different workbooks, but it should act the way you want. Just be sure to make changes to the one that you'll be saving.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[GlennUK]

Yes, you can do that in a single sheet, just create a new Window for the sheet ... menu command Window/New Window, and then compare side by side ( menu command Windows/Compare Side By Side With ), and click the Synchronous Scrolling button ( there'll be a new toolbar appear with Side By Side controls ) to toggle synchronous scrolling on and off.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[djj55]

GlennUK,
Thank you, that works. I have not used new window before or so long ago I did not remember.

djj

 

[GlennUK]

My pleasure :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[AnotherHiggins]

Thanks, Glenn!

djj - might I suggest you reward a STAR to Glenn's answer? That is not only the customary way to show thanks on TT, but also marks the thread as containing useful information for future visitors.

You can do this by click on the
[tab] Thank GlennUK
[tab]for this valuable post!
link at the bottom left of his post.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[djj55]

anotherhiggins,
I never know when to give a star. (I have given one as suggested) The answer was helpful.
djj

 

[AnotherHiggins]

I don't mean to pressure you. And I don't mean to suggest that it isn't appreciated when you take time to post back and say "thanks" - it definitely is. Doing that shows good manners on your part (IMO).

I'll offer my personal guideline for awarding stars in case you might find it helpful. If a post answers the question asked or provides useful information that others might also benefit from, I'll give it a star.

This thread is a good example: Two answers were given. My suggestion would certainly work, but is overly-complex compared to Glenn's reply. So (IMO) Glenn should get the star.

And keep in mind that you can award multiple stars within a single thread, so you don't always have to choose just one reply to 'star'. Again, using this thread as an example, one suggestion was clearly better than the other. So in this case I would just give Glenn a star and not me. But there are occasions when multiple equally-good answers are offered. In those cases you might consider marking more than one post with a star.

(Note: Please do not give me a star in this particular thread. I certainly don't want anyone thinking that I'm soliciting them.)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[djj55]

Thank you,
djj