Displaying across 2 Monitors - XL07

  • Thread starter Thread starter RFJ
  • Start date Start date
R

RFJ

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
 
Hi Rob,

Look here:

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

--
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
| 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
|
|
 
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
 
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.


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

Rob

Chip Pearson said:
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.


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