viewing two worksheets at once

[Jim]

Is it possible to view two different worksheets at the
same time? Especially, how to do this if both are in the
same workbook?

I would like to compare related entries in two different
worksheets, to update the one from the other. (The
worksheets have different structures.)

 

[Peo Sjoblom]

Menu windows>new window and then arrange and select to your liking

 

[Bob Umlas]

Use Window/New Window, then use Window/Arrange, and select windows of active workbook, then change the tab in one of them to view the "other" worksheet. When you're done, close one (the "...:2") by the x in the upper right corner.

 

[Jim]

Bob - marvelous and simple!
None of my books nor Help showed me this - does any book
you have?
Thank you.
Jim

-----Original Message-----
Use Window/New Window, then use Window/Arrange, and

select windows of active workbook, then change the tab in
one of them to view the "other" worksheet. When you're
done, close one (the "...:2") by the x in the upper right
corner.

 

[Peo]

Peo - marvelous and simple!
None of my books nor Help showed me this - does any book
you have?
Thank you.
Jim

 

[Ed]

Try the Excel 2000 (or 2002) Bible by John Walkenbach. Mine (the 2000
version) has a two-page section on that.

Ed