Instagram

Tuesday, March 2, 2010

Open Multiple Excel spreadsheets

A good friend of mine asked me about this today. I expect a GREAT comment!!

This is great for dual monitors.

Excel 2003:
go to Tools -> Options -> General tab.
Make sure the option, ‘Ignore other applications’ is checked.

Excell 2007:
Click the Office button (top left corner of excel) -> Excel Options -> Advanced.
Under the General section, check ‘Ignore other applications that use Dynamic Data Exchange’.

Now all the Excel files will be opened as separate instance and you can move the Excel files individually across the monitors.

3 Comments:

  1. You're a life saver! This also prevents me from having to print the 2nd spreadsheet!Bonus points for going GREEN. you should have your own Captain Morgan commercial! call you "Captain Desktop!"

    Keep the tips coming...you're making me look like a rockstar in my office...

    ReplyDelete
  2. You rock Fre - this has been annoying me for months, but no more!

    ReplyDelete