Dual monitors

Hi,
Does anybody know if Excel 2003 can support the use of dual monitors?
I'm guessing that it involves separate simultaneous starts of two files and
that that may be the limiting factor.

Anybody have any experience in this reagrd?

TIA

I have a three monitor setup (3 NEC flat panel displays
controlled by a Matrox Parahelia video card) and Excel works
fine. You can either maximize Excel on one monitor, or stretch
Excel out across all monitors (to column BG in my case). You can
also stretch the Excel application across all monitors and
display a separate worksheet in each monitor.

You don't have to have two (or more) instances of Excel running
to take advantage of multi-monitor setups. Excel handles multiple
monitors just fine.


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


"GerryK" <GerryK@discussions.microsoft.com> wrote in message
news:FD1BA039-8F77-4239-8D14-9B70406E3682@microsoft.com...
> Hi,
> Does anybody know if Excel 2003 can support the use of dual
> monitors?
> I'm guessing that it involves separate simultaneous starts of
> two files and
> that that may be the limiting factor.
>
> Anybody have any experience in this reagrd?
>
> TIA

It depend on what you are trying to do. Dual monitors are more a function of
the operating system then Excel. I can either have excel running and stretch
the application window over both monitors or I can open two instances of
Excel and place them on separate monitors.

I hope that answers your question.

"GerryK" wrote:

> Hi,
> Does anybody know if Excel 2003 can support the use of dual monitors?
> I'm guessing that it involves separate simultaneous starts of two files and
> that that may be the limiting factor.
>
> Anybody have any experience in this reagrd?
>
> TIA

Thanks, I was hoping it was possible but before I invested in another monitor
and video card, I guess my question nows begs how to open two separte files?
I have always seen only one with the second reduced to the bottom toolbar. Is
there some reconfiguring to do?

TIA

"Chip Pearson" wrote:

> I have a three monitor setup (3 NEC flat panel displays
> controlled by a Matrox Parahelia video card) and Excel works
> fine. You can either maximize Excel on one monitor, or stretch
> Excel out across all monitors (to column BG in my case). You can
> also stretch the Excel application across all monitors and
> display a separate worksheet in each monitor.
>
> You don't have to have two (or more) instances of Excel running
> to take advantage of multi-monitor setups. Excel handles multiple
> monitors just fine.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "GerryK" <GerryK@discussions.microsoft.com> wrote in message
> news:FD1BA039-8F77-4239-8D14-9B70406E3682@microsoft.com...
> > Hi,
> > Does anybody know if Excel 2003 can support the use of dual
> > monitors?
> > I'm guessing that it involves separate simultaneous starts of
> > two files and
> > that that may be the limiting factor.
> >
> > Anybody have any experience in this reagrd?
> >
> > TIA
>
>
>

No, no special operation is required to open two or more files.
Open works exactly the same with two monitors as it does with
one.


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


"GerryK" <GerryK@discussions.microsoft.com> wrote in message
news:F1928982-D244-4C7A-90FA-EF611C5C1595@microsoft.com...
> Thanks, I was hoping it was possible but before I invested in
> another monitor
> and video card, I guess my question nows begs how to open two
> separte files?
> I have always seen only one with the second reduced to the
> bottom toolbar. Is
> there some reconfiguring to do?
>
> TIA
>
> "Chip Pearson" wrote:
>
>> I have a three monitor setup (3 NEC flat panel displays
>> controlled by a Matrox Parahelia video card) and Excel works
>> fine. You can either maximize Excel on one monitor, or stretch
>> Excel out across all monitors (to column BG in my case). You
>> can
>> also stretch the Excel application across all monitors and
>> display a separate worksheet in each monitor.
>>
>> You don't have to have two (or more) instances of Excel
>> running
>> to take advantage of multi-monitor setups. Excel handles
>> multiple
>> monitors just fine.
>>
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting, LLC
>> www.cpearson.com
>>
>>
>> "GerryK" <GerryK@discussions.microsoft.com> wrote in message
>> news:FD1BA039-8F77-4239-8D14-9B70406E3682@microsoft.com...
>> > Hi,
>> > Does anybody know if Excel 2003 can support the use of dual
>> > monitors?
>> > I'm guessing that it involves separate simultaneous starts
>> > of
>> > two files and
>> > that that may be the limiting factor.
>> >
>> > Anybody have any experience in this reagrd?
>> >
>> > TIA
>>
>>
>>

Mr. Pearson,

I came across the email thread while trying to figure out exactly what you
described. However, I am not able to separate the two Excel files onto two
monitors if I have only one copy of Excel running. It is easily done with
two copies of Excel open, so there is a work around, but I am curious how you
separated two files using one Excel running. I can only jump between them
using the "Window" function. Thanks in advance.
Henry McElreath


"Chip Pearson" wrote:

> No, no special operation is required to open two or more files.
> Open works exactly the same with two monitors as it does with
> one.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "GerryK" <GerryK@discussions.microsoft.com> wrote in message
> news:F1928982-D244-4C7A-90FA-EF611C5C1595@microsoft.com...
> > Thanks, I was hoping it was possible but before I invested in
> > another monitor
> > and video card, I guess my question nows begs how to open two
> > separte files?
> > I have always seen only one with the second reduced to the
> > bottom toolbar. Is
> > there some reconfiguring to do?
> >
> > TIA
> >
> > "Chip Pearson" wrote:
> >
> >> I have a three monitor setup (3 NEC flat panel displays
> >> controlled by a Matrox Parahelia video card) and Excel works
> >> fine. You can either maximize Excel on one monitor, or stretch
> >> Excel out across all monitors (to column BG in my case). You
> >> can
> >> also stretch the Excel application across all monitors and
> >> display a separate worksheet in each monitor.
> >>
> >> You don't have to have two (or more) instances of Excel
> >> running
> >> to take advantage of multi-monitor setups. Excel handles
> >> multiple
> >> monitors just fine.
> >>
> >>
> >> --
> >> Cordially,
> >> Chip Pearson
> >> Microsoft MVP - Excel
> >> Pearson Software Consulting, LLC
> >> www.cpearson.com
> >>
> >>
> >> "GerryK" <GerryK@discussions.microsoft.com> wrote in message
> >> news:FD1BA039-8F77-4239-8D14-9B70406E3682@microsoft.com...
> >> > Hi,
> >> > Does anybody know if Excel 2003 can support the use of dual
> >> > monitors?
> >> > I'm guessing that it involves separate simultaneous starts
> >> > of
> >> > two files and
> >> > that that may be the limiting factor.
> >> >
> >> > Anybody have any experience in this reagrd?
> >> >
> >> > TIA
> >>
> >>
> >>
>
>
>

I don't maximize Excel (my video card settings maximize in
individual monitors). Instead, I restore the main Excel window
and drag it to cover to two monitors, then use the Window Arrange
Vertical command two arrange one window in each monitor.

Ctrl+TAB will switch focus between the two windows.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Solomon20" <Solomon20@discussions.microsoft.com> wrote in
message
news:9D9F0BE3-EC81-4FD1-93E9-C5E45EFF8C23@microsoft.com...
> Mr. Pearson,
>
> I came across the email thread while trying to figure out
> exactly what you
> described. However, I am not able to separate the two Excel
> files onto two
> monitors if I have only one copy of Excel running. It is
> easily done with
> two copies of Excel open, so there is a work around, but I am
> curious how you
> separated two files using one Excel running. I can only jump
> between them
> using the "Window" function. Thanks in advance.
> Henry McElreath
>
>
> "Chip Pearson" wrote:
>
>> No, no special operation is required to open two or more
>> files.
>> Open works exactly the same with two monitors as it does with
>> one.
>>
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting, LLC
>> www.cpearson.com
>>
>>
>> "GerryK" <GerryK@discussions.microsoft.com> wrote in message
>> news:F1928982-D244-4C7A-90FA-EF611C5C1595@microsoft.com...
>> > Thanks, I was hoping it was possible but before I invested
>> > in
>> > another monitor
>> > and video card, I guess my question nows begs how to open
>> > two
>> > separte files?
>> > I have always seen only one with the second reduced to the
>> > bottom toolbar. Is
>> > there some reconfiguring to do?
>> >
>> > TIA
>> >
>> > "Chip Pearson" wrote:
>> >
>> >> I have a three monitor setup (3 NEC flat panel displays
>> >> controlled by a Matrox Parahelia video card) and Excel
>> >> works
>> >> fine. You can either maximize Excel on one monitor, or
>> >> stretch
>> >> Excel out across all monitors (to column BG in my case).
>> >> You
>> >> can
>> >> also stretch the Excel application across all monitors and
>> >> display a separate worksheet in each monitor.
>> >>
>> >> You don't have to have two (or more) instances of Excel
>> >> running
>> >> to take advantage of multi-monitor setups. Excel handles
>> >> multiple
>> >> monitors just fine.
>> >>
>> >>
>> >> --
>> >> Cordially,
>> >> Chip Pearson
>> >> Microsoft MVP - Excel
>> >> Pearson Software Consulting, LLC
>> >> www.cpearson.com
>> >>
>> >>
>> >> "GerryK" <GerryK@discussions.microsoft.com> wrote in
>> >> message
>> >> news:FD1BA039-8F77-4239-8D14-9B70406E3682@microsoft.com...
>> >> > Hi,
>> >> > Does anybody know if Excel 2003 can support the use of
>> >> > dual
>> >> > monitors?
>> >> > I'm guessing that it involves separate simultaneous
>> >> > starts
>> >> > of
>> >> > two files and
>> >> > that that may be the limiting factor.
>> >> >
>> >> > Anybody have any experience in this reagrd?
>> >> >
>> >> > TIA
>> >>
>> >>
>> >>
>>
>>
>>

One thing to watch out for, with 2 monitors: if you have two spreadsheets
open (one on monitor A, one on monitor B) and you close spreadsheet A, then
quit Excel, and then send spreadsheet B to a colleague with one monitor, when
he/she opens it, there will be nothing but an empty grey window. The
spreadsheet from monitor B is still there, but out of sight. And since Excel
doesn't detect how many monitors are in use when someone opens a spreadsheet,
it doesn't "know" that it needs to provide a horizontal scroll bar so the
one-monitor user can scroll it into view. I don't know if there's some other
Excel command that will force hidden spreadsheets to pop back to upper left
corner in such a case....maybe so, maybe not. Hope this helps...

"Chip Pearson" wrote:

> I don't maximize Excel (my video card settings maximize in
> individual monitors). Instead, I restore the main Excel window
> and drag it to cover to two monitors, then use the Window Arrange
> Vertical command two arrange one window in each monitor.
>
> Ctrl+TAB will switch focus between the two windows.
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Solomon20" <Solomon20@discussions.microsoft.com> wrote in
> message
> news:9D9F0BE3-EC81-4FD1-93E9-C5E45EFF8C23@microsoft.com...
> > Mr. Pearson,
> >
> > I came across the email thread while trying to figure out
> > exactly what you
> > described. However, I am not able to separate the two Excel
> > files onto two
> > monitors if I have only one copy of Excel running. It is
> > easily done with
> > two copies of Excel open, so there is a work around, but I am
> > curious how you
> > separated two files using one Excel running. I can only jump
> > between them
> > using the "Window" function. Thanks in advance.
> > Henry McElreath
> >
> >
> > "Chip Pearson" wrote:
> >
> >> No, no special operation is required to open two or more
> >> files.
> >> Open works exactly the same with two monitors as it does with
> >> one.
> >>
> >>
> >> --
> >> Cordially,
> >> Chip Pearson
> >> Microsoft MVP - Excel
> >> Pearson Software Consulting, LLC
> >> www.cpearson.com
> >>
> >>
> >> "GerryK" <GerryK@discussions.microsoft.com> wrote in message
> >> news:F1928982-D244-4C7A-90FA-EF611C5C1595@microsoft.com...
> >> > Thanks, I was hoping it was possible but before I invested
> >> > in
> >> > another monitor
> >> > and video card, I guess my question nows begs how to open
> >> > two
> >> > separte files?
> >> > I have always seen only one with the second reduced to the
> >> > bottom toolbar. Is
> >> > there some reconfiguring to do?
> >> >
> >> > TIA
> >> >
> >> > "Chip Pearson" wrote:
> >> >
> >> >> I have a three monitor setup (3 NEC flat panel displays
> >> >> controlled by a Matrox Parahelia video card) and Excel
> >> >> works
> >> >> fine. You can either maximize Excel on one monitor, or
> >> >> stretch
> >> >> Excel out across all monitors (to column BG in my case).
> >> >> You
> >> >> can
> >> >> also stretch the Excel application across all monitors and
> >> >> display a separate worksheet in each monitor.
> >> >>
> >> >> You don't have to have two (or more) instances of Excel
> >> >> running
> >> >> to take advantage of multi-monitor setups. Excel handles
> >> >> multiple
> >> >> monitors just fine.
> >> >>
> >> >>
> >> >> --
> >> >> Cordially,
> >> >> Chip Pearson
> >> >> Microsoft MVP - Excel
> >> >> Pearson Software Consulting, LLC
> >> >> www.cpearson.com
> >> >>
> >> >>
> >> >> "GerryK" <GerryK@discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:FD1BA039-8F77-4239-8D14-9B70406E3682@microsoft.com...
> >> >> > Hi,
> >> >> > Does anybody know if Excel 2003 can support the use of
> >> >> > dual
> >> >> > monitors?
> >> >> > I'm guessing that it involves separate simultaneous
> >> >> > starts
> >> >> > of
> >> >> > two files and
> >> >> > that that may be the limiting factor.
> >> >> >
> >> >> > Anybody have any experience in this reagrd?
> >> >> >
> >> >> > TIA
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>