Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    West Midlands, UK
    Thanked 2 Times in 2 Posts

    Excel 2003 - split screen

    Windows 7 Home Premium, Office 2003

    I have no difficulty getting a copy of each of two Word files up at the same time, one either side, using the Start key+left/right arrow, but I cannot do the same in Excel - whenever I bring up the second file the first disappears. I have tried bringing up two copies of Windows Explorer in split screens left/right, and opening from there, but when I bring up the second Excel file the first always disappears. Is it possible to get two Excel files up at once.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Manning, South Carolina
    Thanked 1,455 Times in 1,324 Posts

    You can do it but not the way you want. After you have the first file open by whatever method you need to hold Shift down and click on the Excel Icon on the Task bar to open the second copy then use the File Open feature of Excel to open the second file. Note: you'll get a mesage about Personal.xls already being open{ if you have a Personal.xls file } just click on the Read Only option. HTH
    May the Forces of good computing be with you!


    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

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

    mike21 (2013-03-24)

  4. #3
    3 Star Lounger JC Zorkoff's Avatar
    Join Date
    Dec 2009
    Boston, Massachusetts, USA
    Thanked 45 Times in 40 Posts
    There is another option. Excel can display multiple windows inside the main program window.

    Assuming that you are viewing the sheet in full screen mode, you will see 3 icons in the upper right corner under the normal program minimize and close buttons.
    They are dash, double boxes, and X. Click the double box icon and the sheet will shrink inside the display area. Open another sheet and it will be visible as well. Now you can resize and move them like any window.

    When you are done, just click the box in the upper right corner of either window to restore a full screen sheet view.

  5. The Following User Says Thank You to JC Zorkoff For This Useful Post:

    mike21 (2013-03-24)

  6. #4
    New Lounger
    Join Date
    Mar 2013
    Thanked 0 Times in 0 Posts
    I have always done using what JCZ just mentioned.

Posting Permissions

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