How to open two spreadsheets in two windows?

  • Thread starter Thread starter Osama
  • Start date Start date
O

Osama

I have figured out how to open two excel files in separate windows. However,
I realized that many functions had been disabled by this option. I have tried
to reverse the process to go back to the original (defulat setting) but no
success! Any help in this matter?
 
If you open two sessions of Excel (clicking on the Excel icon twice), this
will disallow referencing the other sheet.

Better to have one open in an instance, then open another using the File -
Open menu.

Once both are open go to Tools - Options - View tab - Windows in Taskbar.

Now you should see two windows and be able to reference across workbooks.
 
Check Tools ->Options -> General -> Ignore Other Applications (it should be
unchecked).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel spreadsheets opening at top instead of bottom. 4
Two Instances 3
How to open two Excel files in separate windows? 4
Why when opening a spreadsheet, do two copies appear to open? 3
open spreadsheets into separate excel instance 1
Identify files on two diff spreadsheets 1
comparing two separate spreadsheets 3
How to open workbook in two separate Excel windows? 4

Back
Top