Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

excel on two monitors

Options
  • 16-06-2017 12:09pm
    #1
    jem
    Registered Users Posts: 1,031 ✭✭✭


    Hi Have two monitors ,
    No problem two word doc's open, one on each screen likewise internet etc.
    Can't seem to do this with excel
    I would like to have two workbooks open at the same time one on each screen
    Any ideas how to get this working please.
    j


Comments

  • Options
    #2
    gmisk
    Registered Users Posts: 32,304 ✭✭✭✭gmisk


    Can you not just open two instances of excel and open one file in each?


  • Options
    #3
    cruizer101
    Registered Users Posts: 3,205 ✭✭✭cruizer101


    Excel is funny about multiple windows its annoying.
    If you open up one spreadsheet, then right click on the excel icon in taskbar to open a new spreadsheet that should open it in a new window in which you can the open the excel file you want. Don't know why they made it so unintuitive.


  • Options
    #4
    TimeToShine
    Registered Users Posts: 4,881 ✭✭✭TimeToShine


    Create a copy of the workbook and drag it out.


  • Options
    #5
    3102derek
    Registered Users Posts: 574 ✭✭✭3102derek


    What version excel are you running. It works fine for me on 2013 win10. Different spreadsheet one each screen. you could also try open excel twice and move one to the second screen


  • Options
    #6
    GavRedKing
    Registered Users Posts: 53,262 ✭✭✭✭GavRedKing


    jem wrote: »
    Hi Have two monitors ,
    No problem two word doc's open, one on each screen likewise internet etc.
    Can't seem to do this with excel
    I would like to have two workbooks open at the same time one on each screen
    Any ideas how to get this working please.
    j

    The below is what I usually do.
    gmisk wrote: »
    Can you not just open two instances of excel and open one file in each?


  • Advertisement
  • Options
    #7
    Meeeee79
    Registered Users Posts: 465 ✭✭Meeeee79


    You need to open 2 instances of excel or else they wont drag to separate screens. Open the workbook you are working on and to open a second workbook you must open excel through your start program or desktop shortcut, if you open as normal it will open in the same instance of the original workbook and wont drag across


  • Options
    #8
    DamoKen
    Registered Users Posts: 1,269 ✭✭✭DamoKen


    As already said open an additional instance of Excel, drag it to the other monitor and open another spreadsheet there.

    Unlike Word where each doc is a separate instance only way I could find until Microsoft realise tabs are not just useful in browsers


  • Options
    #9
    jem
    Registered Users Posts: 1,031 ✭✭✭jem


    Thanks the opening through the start button worked.
    j


  • Options
    #10
    Meeeee79
    Registered Users Posts: 465 ✭✭Meeeee79


    jem wrote: »
    Thanks the opening through the start button worked.
    j

    Glad to be of assistance :D


Advertisement