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,682
    Thanks
    121
    Thanked 666 Times in 607 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,682
    Thanks
    121
    Thanked 666 Times in 607 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,284
    Thanks
    3
    Thanked 193 Times in 179 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,936
    Thanks
    139
    Thanked 510 Times in 486 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,936
    Thanks
    139
    Thanked 510 Times in 486 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
  •