Displaying across 2 Monitors

Displaying across 2 Monitors - XL07

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RFJ - 09 Oct 2007 09:25 GMT

I've got a modelling spreadsheet comprising several worksheets - one
worksheet has a set of global parameters that I can adjust, another has a
set of statistical tables showing the impact of those parameters.

I want to be show the parameter worksheet on one monitor and the stats
worksheet on another.

The monitors /are/ set up and working correctly <G> and I can drag an excel
window from one to another or get it to span both. But I'm having difficulty
getting the two worksheets to show separately.

Is there a way I can do it.

TIA

Rob

Reply to this Message

Niek Otten - 09 Oct 2007 10:06 GMT

Hi Rob,

Look here:

http://www.cpearson.com/excel/MultipleMonitors.aspx

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| I've got a modelling spreadsheet comprising several worksheets - one
| worksheet has a set of global parameters that I can adjust, another has a
[quoted text clipped - 12 lines]
|
| Rob

Reply to this Message

RFJ - 09 Oct 2007 15:07 GMT

Hi Niek,

Thanks for that.

That seems a good solution for two separate files - and I got it working
first time <G>

I can't seem to do it though for 2 worksheets in the same file which is what
I'm really trying to achieve.

So any other help from anyone will still be appreciated.

Rob

> Hi Rob,
>
[quoted text clipped - 21 lines]
> |
> | Rob

Reply to this Message

Chip Pearson - 09 Oct 2007 17:48 GMT

You can certainly do this. Stretch the main Excel Application window across
two monitors. Then click the View "menu", and click "New Window" in the
"Window" panel. This will create a new window. Click the Restore window
button (between the Minimize and Close buttons in the upper left of the
worksheet window, NOT the Application window's Restore button). Now, resize
the first window to fill your left monitor and then drag the second window
into the right monitor. Both windows need to be in the sizable mode, not
maximized.

This works for me in XL 2007 using up to 4 monitors.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

> I've got a modelling spreadsheet comprising several worksheets - one
> worksheet has a set of global parameters that I can adjust, another has a
[quoted text clipped - 12 lines]
>
> Rob

Reply to this Message

RFJ - 11 Oct 2007 10:21 GMT

Tx Chip - worked a treat :)

Rob

> You can certainly do this. Stretch the main Excel Application window
> across two monitors. Then click the View "menu", and click "New Window" in
[quoted text clipped - 23 lines]
>>
>> Rob

Reply to this Message