• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

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

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?
1 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
Richard DanekeAdjunct FacultyCommented:
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.
ZuZuPetalsAuthor Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now