Working with Excel spreadsheets on a dual monitor setup

Excel, Spreadsheets

While this is not a file conversion issue, I thought you might find it interesting. I work a lot with Excel files and occasionally I need to open more than one file and compare them side by side. I have two monitors set up for when I have really big projects going and it’s a convenient way to manipulate the two files side by side.

The difficulty that I have run into is that Excel will not allow you to separate two open files so that you can view them on separate monitors. While you can compare them side by side on the same monitor, this is not always sufficient because you can’t manipulate the separate files or navigate them with ease. You also have a very narrowed view of each file.

Here is where Open Office once again comes to the rescue! What I simply do is open the one Excel file in Excel and the other in Open Office, and then drag one onto my second monitor, and viola! I have a perfect setup to independently manipulate the two files, having a full screen view of each. Given that Open Office Calc has the same functionality as Excel, this has so far proved to be the workable solution for working on two Excel files at the same time. And best of all, ofcourse, is the Open Office is completely free!

FYI, Word allows you the ability to separate two open files onto to separate monitors. For some reason Microsoft did not see fit to allow Excel to do this too!

I’ve discussed the usefulness of Open Office in my previous post Extracting slides from a Power Point presentation file.

2 Comments

2 Responses

  1. Bucky  •  July 28, 2008 @7:14 pm

    Actually, there is a way. You can have 2 instances of Excel open. Instead of double clicking an Excel file to open it, start another instance of Excel by going through the Start > Programs menu. Then use File > Open to open the file you want. Since you are using 2 separate instances of Excel, you can view both of them at the same time and separate into different monitors.

  2. admin  •  July 29, 2008 @9:31 am

    Bucky,
    You’re absolutely right!! I can’t believe I missed that. I am so used to double clicking to open my files that I hadn’t thought of opening a second instance of Excel.
    Works great!

    thanks again

Leave a Reply

Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>