#267 Display Multiple Excel Worksheets Side-by-Side

Several people have asked about how to see multiple Excel worksheets side-by-side at the same time. Depending what you want to do, here a few tricks you can try to save yourself some toggling back and forth.

2 or More Worksheets of Different Workbooks

1. Open the workbooks you want to view.

2. On the Window menu, click Arrange.

3. Under Arrange, click the option you want.

2 or More Worksheets of the Same Workbook

1. From the Window menu, click New Window.

2. Switch to this new window and click on the sheet/tab you want to view.

3. From the Window menu, select Arrange and check the Windows of active workbook check box.

3. Then just, click the option you want and hit the OK button.

Voila! Two windows displaying different tabs of the same workbook.

Make Use of That Second Monitor

If you’re fortunate enough to have a second monitor, one trick you can try to see a different worksheet on each screen is a bit counter-intuitive. The steps are the same as above but before you do that UN-maximize your Excel application window and size it so it spans across both monitors.

You just need to use the Restore button from the top right corner of the Excel window (shown below) and then resize so it fills BOTH screens.

About these ads

11 thoughts on “#267 Display Multiple Excel Worksheets Side-by-Side

  1. Thanks so much for this. I’m a writer out of Widgelli, Australia and what I just read here on wordpress.com couldn’t
    be said much better. Going through this information reminds
    me of my old roommate, Yvette. He always kept preaching about this.
    I will definitely send this stuff to him. Pretty sure he will have
    a very good read. I appreciate you for posting this.

    Like

  2. kevin says:

    Hi, I cant make the two monitors work? Trying to open the same workbook, different tab on different monitors that way i can cut and paste links
    Thanks
    Kevin

    Like

  3. Mike Price says:

    I do the two monitor trick all the time in both Excel and Power Point (when stealing slides from my previous presentations or when comparing them). In Excel, I’d really like to scroll through the spreadsheets and keep the two windows in synch. Show me how to do that & you’ll be my hero for the day (maybe even the whole weekend!)

    BTW, I prefer to keep the Excel windows in one instance. This allows me to copy/move whole tabs between the spreadsheets. As I recall, you can’t do that between two instances.

    Like

  4. Brent Stegner says:

    Great job with the tips! I have always wanted to be able to use both monitors for larger spreadsheets or when working with two and did not think about the “counter-intuitive” method you described. Thanks.

    Like

  5. Emily Thackery says:

    I am with Randy and I tend to open to versions of excel so I can work on two monitors. What I am wondering though is there a way to automatically open a new version of excel when opening a different worksheet?

    Like

    • Thanks Randy that is another option. Personally, with the antiquated computer that I am stuck with I try to minimize the number of applications running at one time but if your PC will handle that is a great option too.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s