Two displays, one showing one sheet only

rireland

Board Regular
Joined
Feb 12, 2004
Messages
64
I use Excel for a sports scoring system. Sheets 1 to 5 have all the input info & minor placings. Sheet 6 is the results of the previous 5 sheets and the one the crowds want to see. What I want to do is connect a projector to the video output of the laptop & have sheet 6 permanently displayed (while we still input info to sheets 1-5.) Project to big screen for all to see! So:
1. Can the video output be different to the laptop display ( & if not is there a card I can buy to acheive that)
2. How can you make the second video ouput be a certain sheet of a workbook?
Thanks
Richard
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
A bit of hand-waving here because I haven't set one up, but did some research on the possibility a while back...

If your funds stretch to it, the way to go is with a dual-monitor setup. If you are using the on-board graphics, buy a card that fits into your PC -- you'll need to check out what to get here. Some cards have dual monitor outputs.

Anyway, what you do is:
1. Open the working copy on monitor 1
2. In Excel, Window> New Window and put that copy on monitor 2. Select Sheet6. This will be the monitor that feeds the output to the projector.

You work away on the main copy, updating Sheets 1-5. Monitor2 displays the collated results. Corwd is happy. You're happy. Or something like that :biggrin:

Denis
 

rireland

Board Regular
Joined
Feb 12, 2004
Messages
64
dual display

Thanks for fast reply Denis.
Looks like the s/w is solved - the hardware might be the problem. Possibly the wrong forum to ask, but what I need, I think, is a PCMCIA card with dual video outputs? Do they exist?
Quick research found a few for desktops at huge prices, designed for v high res gaming. Don't need speed or res, just 2 outputs!
Richard
 

mrhartley

Well-known Member
Joined
Mar 8, 2005
Messages
564
Hi,

Dont know if this helps but my Dell Laptop has a docking station that has two video outputs which I use for dual monitors.

Maybe a docking station with two video outputs might be cheaper than what you have found.

~Mark
 

Watch MrExcel Video

Forum statistics

Threads
1,113,794
Messages
5,544,322
Members
410,603
Latest member
rseckler
Top