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?
LVL 2
ZuZuPetalsAsked:
Who is Participating?
 
reitzenCommented:
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
0
 
Richard DanekeTrainerCommented:
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.
0
 
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.