Group:  Microsoft Excel ยป microsoft.public.excel.newusers
Thread: Viewing multiple spreadsheets

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Viewing multiple spreadsheets
"Mike Knoblock" <mknoblock[ at ]gmail.com> 14.07.2006 20:14:06
I have Excel 2003 Professional. I'd like to look at two spreadsheets at a
time, but each in its own window. Excel defaults to opening each new
spreadsheet as another workbook in the current window. If each were in its
own window, I could have one spreadsheet on the left monitor, and the other
on the right monitor.

Thanks for any help!!

Mike


Re: Viewing multiple spreadsheets
gls858 <gls858[ at ]yahoo.com> 14.07.2006 20:33:06
Mike Knoblock wrote:
[Quoted Text]
> I have Excel 2003 Professional. I'd like to look at two spreadsheets at a
> time, but each in its own window. Excel defaults to opening each new
> spreadsheet as another workbook in the current window. If each were in its
> own window, I could have one spreadsheet on the left monitor, and the other
> on the right monitor.
>
> Thanks for any help!!
>
> Mike
>
>

Start Excel twice. With two instance of Excel open call up your sheets
one in each window.

gls858
Re: Viewing multiple spreadsheets
"Mike Knoblock" <mknoblock[ at ]gmail.com> 14.07.2006 20:43:35
Yipes. Sure enough. thanks.


"gls858" <gls858[ at ]yahoo.com> wrote in message
news:Ov9e3S4pGHA.2400[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text]
> Mike Knoblock wrote:
>> I have Excel 2003 Professional. I'd like to look at two spreadsheets at
>> a time, but each in its own window. Excel defaults to opening each new
>> spreadsheet as another workbook in the current window. If each were in
>> its own window, I could have one spreadsheet on the left monitor, and
>> the other on the right monitor.
>>
>> Thanks for any help!!
>>
>> Mike
>
> Start Excel twice. With two instance of Excel open call up your sheets
> one in each window.
>
> gls858


Re: Viewing multiple spreadsheets
"Chip Pearson" <chip[ at ]cpearson.com> 14.07.2006 20:45:28
Resize your Excel application window to cover both monitors. The
open your workbooks and go to the Window menu and choose Arrange.


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


"Mike Knoblock" <mknoblock[ at ]gmail.com> wrote in message
news:XlTtg.5479$Oh1.5443[ at ]news01.roc.ny...
[Quoted Text]
> Yipes. Sure enough. thanks.
>
>
> "gls858" <gls858[ at ]yahoo.com> wrote in message
> news:Ov9e3S4pGHA.2400[ at ]TK2MSFTNGP03.phx.gbl...
>> Mike Knoblock wrote:
>>> I have Excel 2003 Professional. I'd like to look at two
>>> spreadsheets at a time, but each in its own window. Excel
>>> defaults to opening each new spreadsheet as another workbook
>>> in the current window. If each were in its own window, I
>>> could have one spreadsheet on the left monitor, and the other
>>> on the right monitor.
>>>
>>> Thanks for any help!!
>>>
>>> Mike
>>
>> Start Excel twice. With two instance of Excel open call up
>> your sheets
>> one in each window.
>>
>> gls858
>
>


Re: Viewing multiple spreadsheets
gls858 <gls858[ at ]yahoo.com> 14.07.2006 20:47:49
Mike Knoblock wrote:
[Quoted Text]
> Yipes. Sure enough. thanks.
>
>
> "gls858" <gls858[ at ]yahoo.com> wrote in message
> news:Ov9e3S4pGHA.2400[ at ]TK2MSFTNGP03.phx.gbl...
>> Mike Knoblock wrote:
>>> I have Excel 2003 Professional. I'd like to look at two spreadsheets at
>>> a time, but each in its own window. Excel defaults to opening each new
>>> spreadsheet as another workbook in the current window. If each were in
>>> its own window, I could have one spreadsheet on the left monitor, and
>>> the other on the right monitor.
>>>
>>> Thanks for any help!!
>>>
>>> Mike
>> Start Excel twice. With two instance of Excel open call up your sheets
>> one in each window.
>>
>> gls858
>
>
No problem. Sometimes the really easy solutions are the hardest ones
to see :-)

gls858
Re: Viewing multiple spreadsheets
slickS <slickS.2cqw1s_1155920113.6297[ at ]excelforum-nospam.com> 18.08.2006 16:54:02
after installing MO Pro 2003, I had the same frustrations. I also run mutliple monitors and find it easier when excel opens a workbook in its own window.

the solutions provided both work (thank you), but is there a more efficient solution to having four seperate windows for each workbook without having to open Excel four seperate times before opening the specific workbooks. (i prefer not to strech the excel workspace across all four monitors as sometimes I will have other applicatios open behind excel that switch to while still wanting to work with one or two excel workbooks).

My preference would be to simply click on the file names of the excel files I wanted to open in seperate windows without having to open excel four times and then selecting the right file for each window.

thanks -- slickS ------------------------------------------------------------------------ slickS's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37727 View this thread: http://www.excelforum.com/showthread.php?threadid=561625
Re: Viewing multiple spreadsheets
slickS <slickS.2cqwa4_1155920425.632[ at ]excelforum-nospam.com> 18.08.2006 17:00:11
after installing MO Pro 2003, I had the same frustrations. I also run mutliple monitors and find it easier when excel opens a workbook in its own window.

the solutions provided both work (thank you), but is there a more efficient solution to having four seperate windows for each workbook without having to open Excel four seperate times before opening the specific workbooks. (i prefer not to strech the excel workspace across all four monitors as sometimes I will have other applicatios open behind excel that switch to while still wanting to work with one or two excel workbooks).

My preference would be to simply click on the file names of the excel files I wanted to open in seperate windows without having to open excel four times and then selecting the right file for each window.

thanks -- slickS ------------------------------------------------------------------------ slickS's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37727 View this thread: http://www.excelforum.com/showthread.php?threadid=561625

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net