Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I wish to view 2 Excel 2007 files in 2 different Excel windows, although there are 2 "Excels" in the task bar, they both points to the same app. how can I make it split (like word)?

share|improve this question
add comment

3 Answers 3

up vote 8 down vote accepted

Launch Excel twice (quickest way is pressing the Windows logo and typing Excel)

Open each Excel file in a seperate instance of Excel, you can now order them side by side if you like or move them to another monitor.

To get them side by side nicely, press Windows + Left/Right arrow to have it stick to either half of the screen.

share|improve this answer
    
:-) ha... I can't believe it is as that simple. IS there a way to split a current excel app (with 3 windows) into a new instance ? –  Dani Feb 9 '10 at 11:33
    
You might be able to drag the workbooks between different Excel instances –  Ivo Flipse Feb 9 '10 at 11:38
    
Hard to believe that you have to do this in such a roundabout way... it shouldn't be this difficult and counter-intuitive. Thanks Ivo :-) –  Amos M. Carpenter Apr 16 at 1:39
add comment

There is a setting in Excel that controls the appearance of Excel on the taskbar. You can read about it here. You may also want to turn off Direct Data Exchange so Excel launches in separate instances.

share|improve this answer
    
The task bar appearance is OK. the problem was that opening a new document from the same instance prevents me from putting them side by side in difference excel instances. I will check that DDE feature. –  Dani Feb 9 '10 at 11:34
add comment

I much prefer to keep the files in the same instance of excel. There are a number of features that don't work between files if you open in different instances (as in Ivo's answer). Another way to accomplish this is to open the 2 files in the same excel window, then go to View > Arrange All, then select Vertical and press OK. Same excel window, but can now view 2 files at once.

You can even view 2 sheets of the same file this way. The only difference is that first you must select View > New Window.

There are times where I use Ivo's method. Mainly when I have files with macros that I need to test or compare to other versions. I find it best to separate the instances and processes.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.