Pasting from another spreadsheet changes formatting

R

Ronan

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
 
O

Office Helper

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