Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beatrix
 
Posts: n/a
Default 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,
  #2   Report Post  
Posted to microsoft.public.excel.misc
Joe Mac
 
Posts: n/a
Default 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,

  #3   Report Post  
Posted to microsoft.public.excel.misc
Beatrix
 
Posts: n/a
Default 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,
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert Rows with Formulas in Place on Multiple Sheets? Michael Link Excel Discussion (Misc queries) 5 March 9th 06 01:54 PM
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc EDSTAFF Excel Worksheet Functions 0 November 14th 05 03:27 PM
In 3 active sheets in wkbk, determine& display the # of sheets that have data wrpalmer Excel Discussion (Misc queries) 1 November 4th 05 02:01 PM
Switching between sheets in same window... Kojones Excel Discussion (Misc queries) 1 July 16th 05 10:16 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM


All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"