Dual monitors...

[Aquaphire]

Hey guys,

I'm doing lots of spreadsheet work and I'm trying to figure out how to work...faster.

I have two spreadsheets open in two seperate instances of Excel on two different screens. However, I noticed that when i copy data from one spreadsheet over to the next, I can't copy formulas. (Paste special gives the "paste as bitmap" option only).

Any way around this?

Thanks!

 

[Andrew Poulsom]

You need the workbooks to be in the same instance of Excel.

 

[Aquaphire]

You need the workbooks to be in the same instance of Excel.

no way around that huh? damnit... so annoying ><

 

[RoryA]

You can stretch one instance of Excel across two screens and arrange the workbooks side-by-side. That's what I do.