Pasting from another spreadsheet changes formatting
 

I'm copying data from one spreadsheet to another. When I do this, all
formatting (i.e. font color, borders, graph colors, etc.) for other tabs in
the copied to spreadsheet changes.

Any ideas on how to prevent this?

Thanks,
Ronan

Pasting from another spreadsheet changes formatting
 

You will have to do a Paste Special and choose Value. That way only the
number will come across, not the formatting.

"Ronan" wrote:

I'm copying data from one spreadsheet to another. When I do this, all
formatting (i.e. font color, borders, graph colors, etc.) for other tabs in
the copied to spreadsheet changes.

Any ideas on how to prevent this?

Thanks,
Ronan