ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   All sheets in the same window??? (https://www.excelbanter.com/excel-discussion-misc-queries/89278-all-sheets-same-window.html)

Beatrix

All sheets in the same window???
 
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,

Joe Mac

All sheets in the same window???
 
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.
--
Thanks for your help -
Joe Mac


"Beatrix" wrote:

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,


Beatrix

All sheets in the same window???
 
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,

David Biddulph

All sheets in the same window???
 
"Joe Mac" wrote in message
...

"Beatrix" wrote:


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.


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.


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.
--
David Biddulph




All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com