Dual monitors, dual excels

[Igor Z]

I am trying to copy and paste from one excel to another. The reason i have
two seperate excels open is because i have dual monitors and that is the
only way i know how to get excel to show up on both screens. When i try to
paste it will only paste values and it will not paste the formulas. Also
when i try to paste special it does not give me the usual paste special
menu. How can I get around this problem?

Thank you,
Igor

 

[Dave Peterson]

If you open one instance of excel and arrange the windows nicely, you should be
ok.

I'd start with Chip Pearson's notes:
http://cpearson.com/excel/MultipleMonitors.aspx

 

[Ken Wright]

Don't maximise the Application window and you will be able to drag it to a
size that spreads across the two screens - Then simply open two or more
files and tile them within Excel using Window / Arrange. I work like this
every day, and I couldn't imagine going back to one monitor now. Also gives
you a great view of wide spreadsheets with data across a lot of columns.

Regards
Ken.................

 

[Chip Pearson]

I'd start with Chip Pearson's notes:
http://cpearson.com/excel/MultipleMonitors.aspx

I now have, count'em, 4x26" flat panel monitors. It is boss.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Ken Wright]

LOL - Chip, I can just picture you sat in front of that setup with a rather
big smile on your face

Hope all is well with you.

Best Wishes
Ken.....................................

 

[Mike Middleton]

Chip -

What video card(s) do you use?

- Mike

Email (e-mail address removed)

 

[Chip Pearson]

What video card(s) do you use?

The machine has two NVidia PCIex GeForce 9800 video cards, each of
which has 1GB video RAM and controls two monitors.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)