Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Location
    West Midlands, UK
    Posts
    236
    Thanks
    233
    Thanked 2 Times in 2 Posts

    Two open Excel files on a split screen

    I use MS Office 2003. I have no difficulty in displaying two Word files side by side on my screen, but cannot find a way to do the same with Excel files - I often wish to cut/paste from one file to the other. I know there is a way but cannot work it out.

  2. #2
    Super Moderator Rick Corbett's Avatar
    Join Date
    Dec 2009
    Location
    South Glos., UK
    Posts
    2,143
    Thanks
    101
    Thanked 580 Times in 464 Posts
    Does this Excel files side by side thread help?

  3. The Following User Says Thank You to Rick Corbett For This Useful Post:

    mike21 (2016-02-06)

  4. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Open your first file, then open your second file.
    Now from the top menu, select Window > Arrange > and click the vertical option.

    In 2010, it's different...it's under View.

    Clip0002.jpg
    Last edited by kweaver; 2016-02-05 at 16:32.

  5. The Following 2 Users Say Thank You to kweaver For This Useful Post:

    mike21 (2016-02-06),mrjimphelps (2016-02-06)

  6. #4
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,411
    Thanks
    447
    Thanked 405 Times in 377 Posts
    I have Excel 2010. The following may also be true of Excel 2003.

    As described by what Rick linked to in post #2:

    The only way I have found that Excel will let me have two separate Excel sessions side-by-side is as follows:
    1. Open the first spreadsheet. This will be the 1st Excel session.
    2. Open Excel, without loading any spreadsheet. This will be the 2nd Excel session.
    3. Separate the two sessions into two separate windows.
    4. Open the desired spreadsheet in the new, blank session.

    If I try to open the 2nd spreadsheet directly by double clicking on it, it won't be a separate Excel session, but rather will be tied to the 1st Excel session.

  7. The Following User Says Thank You to mrjimphelps For This Useful Post:

    mike21 (2016-02-06)

  8. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Hey Y'all,

    In Office 2010 you can open a 2nd, 3rd, 4th, etc. instance of any of the programs by holding down the Shift key while clicking on the program icon.

    Note: if you have a Personal Macro file (Personal.xls / .xlsx, .xlsm, etc.) you will have to answer the prompt on how to open it I always choose Read Only.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  9. The Following 2 Users Say Thank You to RetiredGeek For This Useful Post:

    mike21 (2016-02-06),mrjimphelps (2016-02-06)

  10. #6
    3 Star Lounger
    Join Date
    Dec 2009
    Location
    West Midlands, UK
    Posts
    236
    Thanks
    233
    Thanked 2 Times in 2 Posts
    Thanks for all the suggestions. Holding down the shift key worked and is simple - if I can remember it. Another way I have just tried is to have an Excel shortcut on the desktop in addition to the one on the taskbar, both will then open files. The first way would be easier and would allow several open files

Posting Permissions

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