All sheets in the same window???

B

Beatrix

Hi!

I'd like to change the settings so I can see two or more xls sheets the same
time, but not in the same window. I guess this is not an excel setup, but I
don't know where to set it.

Thank you,
 
J

Joe Mac

If you're trying to see multiple "spreadsheets" in one Excel window you can
use the Windows/Arrange option to view in either tiled, Horizontal, Vertical
or Cascade...
If you're trying to see multiple "spreadsheets" in different windows you can
simply open another Excel session to view the second "spreadsheet"...
If you're trying to see multiple "worksheets" from the same "spreadsheet" in
a single window, that is not possible to my knowledge.
 
B

Beatrix

It is possible to use two different windows for word, excel, access, etc, to
click and draw info from one table to another.

And my biggest problem is, I'm not used to it, that excel closes all sheets
at the same time, if I click in the corner X. That is terrible.

Pls write only if you know how to change the setup.

Thanks,
 
D

David Biddulph

"Beatrix" wrote:
Click to expand...
If you're trying to see multiple "spreadsheets" in one Excel window you
can
use the Windows/Arrange option to view in either tiled, Horizontal,
Vertical
or Cascade...
If you're trying to see multiple "spreadsheets" in different windows you
can
simply open another Excel session to view the second "spreadsheet"...
If you're trying to see multiple "worksheets" from the same "spreadsheet"
in
a single window, that is not possible to my knowledge.
Click to expand...

I'm confused about your distinction between spreadsheet and worksheet. If
you want to see multiple windows on one workbook, whether from the same
worksheet or different, you can do this with Window/ New Window, and you can
then tile or arrange the windows as required just as you can with windows
from different workbooks.
 
Top