Aug 15, 2008

View multiple Excel files at the same

There's a simple setting that allows excel to display multiple files next to or on top of each other (like word, pdf, etc.). This is useful especially if you have two monitors or a large monitor and would like to work on two excel files at the same time.

Here's what you need to do:

Excel 2003: Go to "Tools > Options" Select the “General” tab and place a check mark at “Ignore other Applications”.

Excel 2007: Office Button > Excel Options > Advanced Tab > General Section > "Ignore other Applications that use dynamic data exchange"

Click OK and you are done!.

Also note that there's "side by side comparison" feature of Excel.

No comments: