Opening Multiple Pages in the Same Workbook

L

Linda

I've messed up on inputting info on various pages of my workbook and would like to open two or three pages to do a scroll and check my pages. I've gone to Excel's help page and am advised to open a new document and then arrange my worksheets. Why? I need the info from the one I have open. Does this mean I have to duplicate my workbook and then open that new document? I've tried opening the workbook again, but I get a warning that the workbook is already open. Pardon me but, Duh! So I tried opening it again anyway and it just overlaid and merged. I don't know what it did, but I still could not look and two different pages in the same workbook. Is there a way around this little glitch? I'm working with XP. TIA (oh by the way in the beginning I thought HTH meant help the helpless lol : D)
 
A

Andy Brown

I've messed up on inputting info on various pages of my workbook ...

What do you mean by pages? Worksheets, or pages as they would print the
further you go down the sheet? Whatever the Help says (I haven't checked),
try opening a new *window* of the *same* workbook (use the Window menu).
That way you can look at 2 different areas of the same sheet, or 2 different
sheets of the same workbook, at the same time )once you've arranged them
onscreen).

HTH,
Andy
 
A

A.W.J. Ales

Linda,

I think you just want to open a new window.

Window / New window.
You now have two "windows" to the same file.
NB Pressing the X in the right top corner of the file will now not close the
file, but just that window. The other window (and the file) are still open.
If you have opened a second (or third etc. window) : Notice the filename:2
on the Excel bar

HTH Doesn't it mean that than ??? <bg>

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Linda said:
I've messed up on inputting info on various pages of my workbook and would
like to open two or three pages to do a scroll and check my pages. I've
gone to Excel's help page and am advised to open a new document and then
arrange my worksheets. Why? I need the info from the one I have open.
Does this mean I have to duplicate my workbook and then open that new
document? I've tried opening the workbook again, but I get a warning that
the workbook is already open. Pardon me but, Duh! So I tried opening it
again anyway and it just overlaid and merged. I don't know what it did, but
I still could not look and two different pages in the same workbook. Is
there a way around this little glitch? I'm working with XP. TIA (oh by
the way in the beginning I thought HTH meant help the helpless lol : D)
 

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

Top