How open different Excel 2003 files side-by-side?

Posted on 2011-10-27
Last Modified: 2013-11-08
In Windows 7 I have Excel running with two files open.  I see two Excel icons at the bottom, one for each file.

I can't figure out how to have two Excel programs running at the same time, side-by-side.  

If I click each Excel icon at the bottom, THAT speadsheet is displayed in the single Excel app, back and forth.

This means it's impossible to see two spreadsheet files open at same time to cross-reference them.

I've dug through Excel and I can't seem to find a setting that says something like this:

[x] Multi-Excel Frame Operation

Any ideas?
Question by:ZuZuPetals
    LVL 6

    Accepted Solution

    Two ways you can do this.

    1.  Open Excel and open workbook 1, move to left monitor and maximize window.  Open Excel again and open workbook 2, move to right monitor and maximize window.

    2.  Open Excel with both workbooks click the "Restore down" button in the top right corner (between minimize & maximize), expand Excel so it covers both monitors, click View > Arrange All > Vertical.  This way tends to be a little easier if you're moving data between workbooks
    LVL 18

    Expert Comment

    by:Richard Daneke
    You can use the Arrrange All option in one program copy of Excel 2003 to show the two files split vertically or horizontally.   There is also an option when opened within one program window to synchronize the two windows to make it easier to compare the  two files.  These options are in the Window menu.
    LVL 2

    Author Closing Comment

    Yes, the key is to open Excel manually multiple times and arrange (perhaps on different monitors), then to open files in the respective applications.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    More and more people are using the enhanced small form-factor pluggable (SFP+) tranceivers, and speed is of utmost importance. Testing of speeds are critical to ensure that the devices will meet the speed requirements. There are some testing challen…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now