East Bay Solutions

Opening Excel Workbooks in Two Separate Windows

KB-313

Solution

Problem or Question:

How can I open two Excel Workbooks in separate windows?

Environment:

Office 2007 Office 2010

Solution or Answer:

Unlike previous versions of Excel, you cannot open workbooks in separate windows from within the same Excel instance (program). To see two workbooks in separate windows you must open a separate Excel instance (start Excel a second time from the Start menu or from a shortcut on your desktop) and then open the second file from within that second Excel window. Depending on the complexity of your workbooks, opening two instances of the Excel program may slow down the performance of your processes.

Alternatively, you can view two workbooks in the same window by arranging the view of your open workbook windows from the View toolbar. Information on this can be found at:

http://office.microsoft.com/en-us/excel-help/view-two-or-more-worksheets-at-the-same-time-HP001217043.aspx?CTT=1

Submitted by Vivian Reed vivian.reed@csueastbay.edu




Article Details

Last Updated
29th April 2013 04:05:19 pm

Submitted By
Benjamin Yee

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (152 votes)

69% thumbs up 30% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Related Articles

No related articles were found.

Attachments

No attachments were found.
  • Print This Page
  • Bookmark and Share