Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts

    View side by side in Excel 2013 not same as 2010

    In Dec 2013 I requested help with this. I wanted a side by side view so I could scroll up/down on part of a sheet while seeing other rows of that sheet [or other sheets]. I needed independent up/down scrolling.
    on 12/31/13 sdckapr offered: show them side-by-side and sync them if desired
    on 1/1/14 Maud offered: a macro

    I was using Maud's macro in Excel 2010 and all was fine. Now I am trying to use the same file in Excel 2013. Now the 2 windows open in different instances of Excel, not side by side in the same instance and I cannot "combine" them.

  2. #2
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts
    A link to the original post?

  3. #3
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,641
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Skipro,

    Try recording a macro while setting up the dual pane to the specs you want and see what you get. You can tweak it from there.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    Maud,
    That is the problem, I cannot set it up the way I want, 2 screens in 1 instance of Excel. When I select "new window", it opens a new window in another instance of Excel.
    Is there a setting in "options" I am missing?
    See attached.
    Attached Images Attached Images
    Last edited by skipro; 2014-11-02 at 17:08.

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,641
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Skipro,

    Seems they made a change from the Multiple Document Interface but looks like you can still do it similar. Unless someone else has excel 2013 and can guide you, you will have to do some of the leg work to get us started.

    Please read this article then once you are able to place them side by side the way you want them, record a macro performing the same procedure and post it here.

    http://blogs.office.com/2013/02/07/o...-side-by-side/
    Last edited by Maudibe; 2014-11-02 at 18:06.

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Surely the SDI interface removes this problem completely as you can simply put the windows next to each other and the scrolling is independent? (and they are opening in the same instance, not a separate one)
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    ..and in Excel2013, if you do want the two windows to scroll synchronously, in the [Windows] group in the top-panel ribbon, simply click the option View Side by Side and then click the option Synchronous Scrolling (which is the next option below)

    zeddy

  9. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    ..and the advantage of the Excel2013 version is it is so much easier to have the two windows on adjacent screens i.e. if you aren't working with two screens you should really get a second one now!

    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •