How to open workbook in two separate Excel windows?

C

curiousgeorge408

I am working on a workbook with two worksheets. While developing
Sheet1, I need to constantly look at Sheet2. Obviously, this is very
tedious to do in one Excel window.

Ideally, I would like to open the same workbook in two separate Excel
windows. Alternatively, I would like open the same workbook twice in
the same Excel window. Alternatively, I would like to open two
worksheets from the same workbook concurrently in the same Excel
window.

How can I do that?

It would be fine with me if only one instance of the workbook is
writable. The other instances can be read-only. That is, Sheet1
needs to be writable, but Sheet2 can be read-only.
 
B

Bob Phillips

Menu Window>New Window

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bob Phillips

The value of looking at other threads Faraz <bg>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

How to open two Excel files in separate windows? 4
displaying a name in a cell reference 2
EXCEL - IF(IFERROR(VLOOKUP question 0
Comparing List A to List B and add what's missing from List B 2
TWO SEPARATE WORKBOOKS NEEDED ON EXCEL 07??? 2
Import Multiple CSV Files from Same Folder into Open Workbook 5
How to update a workbook without reopening? 1
How to create absolue path link to another workbook (Excel 2003) 1

Top