View multiple worksheets in same pane

[Chip_McK]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

New to Excel.
I want to view different worksheets of the same workbook
in the same pane/window and to be able to toggle between.
- Seeing both source and destination in same pane/window

My research leads me to believe that this product fails to allow
this. Is this really true?

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

New to Excel.
I want to view different worksheets of the same workbook
in the same pane/window and to be able to toggle between.
- Seeing both source and destination in same pane/window

My research leads me to believe that this product fails to allow
this. Is this really true?

No, it is not really true. Your research is faulty. In the window menu
select New window. Then Arrange from the window menu. Click the arrangement
you want (vertical, horizontal, etc.) Then for each window, simply click on
a window pane, select the sheet tab you want, scroll to the location you
want, etc.

 

[Chip_McK]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

New to Excel.
I want to view different worksheets of the same workbook
in the same pane/window and to be able to toggle between.
- Seeing both source and destination in same pane/window

My research leads me to believe that this product fails to allow
this. Is this really true?

No, it is not really true. Your research is faulty. In the window menu
select New window. Then Arrange from the window menu. Click the arrangement
you want (vertical, horizontal, etc.) Then for each window, simply click on
a window pane, select the sheet tab you want, scroll to the location you
want, etc.
[/QUOTE]

That is a combination that I had not tried. Obviously.

Thanks Bob

- Chip