Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

MS Excel - Multi Window

  • 17-10-2016 11:32AM
    #1
    54and56
    Registered Users, Registered Users 2, Paid Member Posts: 7,999 ✭✭✭


    Hi all,

    I've two screens and I'd like to have one spreadsheet showing on Screen #1 whilst I have another spreadsheet showing on screen #2 at the same time.

    I've Office 2010 V14.

    For the life of me I can't figure out how to do this. It's cracking me up that I've two screens but can only seem to display Excel on a single screen so have to constantly switch between the two spreadsheets to grab data etc.

    Can someone make my day please????


Comments

  • #2
    Taltos
    Registered Users, Registered Users 2 Posts: 20,830 ✭✭✭✭Taltos


    Yup
    Easiest way is to launch Excel a second time and open the 2nd spreadsheet in that.
    Otherwise you'd need to stretch your window settings across the two monitors and enlarge excel which really sounds messy.


  • #3
    54and56
    Registered Users, Registered Users 2, Paid Member Posts: 7,999 ✭✭✭54and56


    Taltos wrote: »
    Yup
    Easiest way is to launch Excel a second time.
    I never knew you could do that!!

    Sorted :D


  • #4
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 95,982 Mod ✭✭✭✭Capt'n Midnight


    Je_suis_Jean wrote: »
    I never knew you could do that!!

    Sorted :D
    Right up until you try cutting and pasting from one instance to the other, depending on which version of excel you have


  • #5
    Antar Bolaeisk
    Registered Users, Registered Users 2 Posts: 3,091 ✭✭✭Antar Bolaeisk


    The other alternative is to upgrade to either 2013 or 2016 which supports per-workbook windows within the one instance.

    The option of launching a second instance of excel for 2010 or below works but comes with a lot of pains and gotchas.


Advertisement