Opening Multiple Pages in the Same Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
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
Click to expand...
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)
 
Linda

With your lone workbook open to sheet1 as an example.

Window>New Window to get a duplicate of sheet1.

Then Window>Arrange>Vertical to get two side by side windows.

Click on tab of sheet2 in one of the windows.

You now have sheet1 and sheet2 in separate windows.

Repeat for more than two windows and sheets.

You can also have separate views of the same worksheet in different windows.
Use the scroll bars to chnage views.

BTW....best to get used to referring to worksheets instead of "pages".

A workbook is a file with one or more worksheets. A worksheet when printed
can have one or more pages to print out.

Gord Dibben Excel MVP
 
I do a lot of "comparing"..........I also have three monitors on my system.
So I just bring up two separate sessions of Excel on two of the monitors and
open the same workbook in each session and can easily switch sheets on
either session.

Vaya con Dios,
Chuck, CABGx3



Linda said:
I've messed up on inputting info on various pages of my workbook and would
Click to expand...
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)
 
Thank you all so much with my question. Yes, I am a newbie and I will work on my Excel Lingo. Worksheets in a Workbook. Sometimes I just can't get the words right so Help can Help me. ; D (I still think Help The Helpless is what it really means!)
 
Linda: I don't know abt XP, but check to see if there's
a "Window" section in the top menu. If so,
click "Window", "new window", then click "window" again
and select "arrange" either vertical or horizontal,
whichever works best for you. This should open a "copy 2"
of your workbook w/o conflict. Just be sure to save BOTH
before you close, just in case.
-----Original Message-----
I've messed up on inputting info on various pages of my
Click to expand...
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)
 
Tess,

You don't have to save both windows before you close.
This option is a setting on filelevel. If you save the file while you have
more than one window open, the setting will be aved with the file.
The next time you open the file, both windows will be open.

--
Regards,
Auk Ales

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