Maintain cell formatting in target cell when using Paste

B

bbotzler

Is there an Excel setting to prevent copied cells from changing the cell
format in the target cells? or in other words... is there a setting to
always treat Paste as if Paste Special | values had been used?

..
 
G

Gord Dibben

You can enable the "show paste options button" in Tools>Options>Edit.

After pasting, click on the button and check the option "match destination
formatting"


Gord Dibben MS Excel MVP
 
Top