Mutiple Excel Windows.

[Guest]

This should be easy, but I am not probably asking the correct question to
help. How do you get mutiple Excel windows to be open at the same time --
NOT selecting spreads from the Windows menu item but Mutiple Windows on the
screen each with there own Excel spreadsheet.


Thanks,
--max

 

[Chip Pearson]

With two workbooks open, go to the Window menu and choose Arrange
then Tiled.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Peo Sjoblom]

In the menu bar select tools>options>view, select windows in task bar

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Gord Dibben]

Window>New Window until you get enough windows.

Then Window>Arrange in the configuration you want.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Thanks for posting Chip.

My "Window>New Window" is only needed when you want to have multiple sheets from
one workbook tiled.


Gord

With two workbooks open, go to the Window menu and choose Arrange
then Tiled.

Gord Dibben MS Excel MVP

 

[Guest]

Thanks for the response Chip.

Somethimes when you open multiple spread sheets, it seems they end be
accumulated under one application. So they only way to access the different
spreadsheets is a) clicking on "Windows" in the toolbar, and choosing the
different spreadsheets. Or b) using Excel as an MDI and having multiple
windows with Excel. What I want to know is how consistently have two
spreadsheets open on the desktop and be able to swap back and forth between
the spreadsheets?

Thanks
--max

 

[Guest]

Thanks Gord for responding so quickly.

Something may be wrong with my installation, but when I do Windows | New
Window all I get is another copy of the current window. So the Windows list
goes form "current.xls" to "current.xls:1" and "current.xls:2" not a new
window like I would expect.

Thanks again,
--max

 

[Gord Dibben]

Correct Max.

I was thinking of one workbook open and multiple sheets in windows.

My mistook<g>


Gord

Thanks Gord for responding so quickly.

Something may be wrong with my installation, but when I do Windows | New
Window all I get is another copy of the current window. So the Windows list
goes form "current.xls" to "current.xls:1" and "current.xls:2" not a new
window like I would expect.

Thanks again,
--max

Gord Dibben MS Excel MVP

 

[Peo Sjoblom]

Did you try my solutions with tools>options>view and selecting windows in
taskbar

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Guest]

Hi Peo, thanks for responding.

I don't know how "selecting windows in taskbar" works, other that to make
entries into the task bar, and allow you to select from the taskar, it
doesn't look like much. When you start a spreadsheet via double clicks in
explorer all you get is more spreadsheets under the Windows menu item.

If you start the second or thrid copy of Excel from the start menu then you
can have multiple copies run, but at some point, I THINK, Excel will gather
the spreadsheets under on entry. At it seems that is what happens.

I thought there was a setting, a way, or something to tell Excel to open
spreadsheets in a seperate window. How? but for now Start | MS Office |
Excel ... File open ... Blah.

Thanks all for your time and trouble.

--max

 

[Saruman]

Go to Window, Arrange and select how you want to view the windows, either
tiled, horizontal, vertical etc and click ok.

The arrange windows of current workbook is designed to work for the multiple
windows feature that you have started using.

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

Correct Max.

I was thinking of one workbook open and multiple sheets in windows.

My mistook<g>


Gord

Thanks Gord for responding so quickly.

Something may be wrong with my installation, but when I do Windows | New
Window all I get is another copy of the current window. So the Windows list
goes form "current.xls" to "current.xls:1" and "current.xls:2" not a new
window like I would expect.

Thanks again,
--max

Window>New Window until you get enough windows.

Then Window>Arrange in the configuration you want.


Gord Dibben MS Excel MVP