Maintain cell formatting in target cell when using Paste

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Target cell showing a ' after I Paste>Special>Value. Why? 2
When I paste>special>value, I get a ' or ^ at the target cell. Why 1
Formatting not protected when paste 7
I can't copy and paste equations 0
Prevent paste from re-formatting cell 4
conditional formatting in Excel 2007 1
Maintain Formatting with Formulas 1
paste and highlight the cells of range 4

Top