+ Reply to Thread
Results 1 to 8 of 8

trouble opening 2 spreadsheet at once.

  1. #1
    Registered User
    Join Date
    09-29-2016
    Location
    Milwaukee, WI
    MS-Off Ver
    2010
    Posts
    3

    trouble opening 2 spreadsheet at once.

    I have 2 monitors and would like to open 1 excel file on the right monitor and open another excel file on the left monitor but every time I open 2 files, one covers the other, I can't separate them on both monitors. At work we can just drag one page to the other monitor but at home I cannot do that.
    HELP

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: trouble opening 2 spreadsheet at once.

    Have you got excel itself set up to show on 2 monitors?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-29-2016
    Location
    Milwaukee, WI
    MS-Off Ver
    2010
    Posts
    3

    Re: trouble opening 2 spreadsheet at once.

    I guess I don't know how to do that! I'm very new to Excel, I'm trying to figure out how everything works. I am still old school, back when Lotus 123 was around!
    Anyhow, I'd appreciate if you were to tell me how to set Excel up for 2 monitors! That's would probably be less of a headache for me.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: trouble opening 2 spreadsheet at once.

    aahh lotus 123, I remember those days too and supercalc

    There are probably other ways, but dont maximize the excel window, then just drag it across both sceens

  5. #5
    Registered User
    Join Date
    09-29-2016
    Location
    Milwaukee, WI
    MS-Off Ver
    2010
    Posts
    3

    Re: trouble opening 2 spreadsheet at once.

    I can't get the images to go to both screens, it's either one or the other. I can however minimize both on one screen side by side but then I have to slide right to see all the columns and that's not what I want to do.

  6. #6
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: trouble opening 2 spreadsheet at once.

    To do this you have to "open" Excel twice.
    Open one of the spreadsheets and drag it onto the other monitor.
    Then open excel again and it will appear on the "original" monitor.
    On this second blank "Excel" locate and open the other spreadsheet you want.

    Regards

    peterrc

  7. #7
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: trouble opening 2 spreadsheet at once.

    Dupicated - deleted

    Regards

    peterrc
    Last edited by peterrc; 10-02-2016 at 08:17 AM.

  8. #8
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: trouble opening 2 spreadsheet at once.

    Yep as peterrc says you need to open Excel twice. Normally the way I do it is open the first file I want and then middle mouse button on the Excel icon pinned to my taskbar. That will open a 2nd session of Excel and then I can navigate to the 2nd file I want open and then move them side by side. Hope this helps.
    Did I help? Click *- add to my rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Having trouble opening a CSV file in excel
    By nordinho in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-02-2013, 05:28 AM
  2. trouble opening a korean slk
    By rabbitspazz in forum Excel General
    Replies: 1
    Last Post: 11-16-2007, 10:55 PM
  3. Trouble opening Word document
    By Richard in forum Excel General
    Replies: 1
    Last Post: 08-02-2006, 09:40 AM
  4. TROUBLE OPENING OLD WORKBOOK VERSION
    By medford1986 in forum Excel General
    Replies: 2
    Last Post: 04-30-2006, 11:10 PM
  5. Trouble opening embedded Excel in PPT
    By JS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2006, 12:10 PM
  6. Trouble opening excel file
    By weimar in forum Excel General
    Replies: 2
    Last Post: 03-07-2006, 01:15 PM
  7. trouble opening excelsheet
    By cmiaoqin in forum Excel General
    Replies: 2
    Last Post: 01-06-2006, 01:54 AM
  8. UGH! Trouble downloading, and opening anything
    By cali in forum Excel General
    Replies: 1
    Last Post: 12-15-2005, 02:40 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1