Is there a way to paste values and formats (but not formulas)?

[kwp004]

Is there a way to paste values and formats (but not formulas)?

 

[Haluk]

Did you try "Paste Special" ?

 

[Rick Rothstein]

Is there a way to paste values and formats (but not formulas)?

You could always do it in two steps. For the range of interest... first Copy/PasteSpecial Constant Values, then Copy/PasteSpecial Constant Formats..

 

[kwp004]

Yes, two steps makes sense. Thanks!

 

[Haluk]

I'm using Office 2010 and "Paste Special" menu has a 1 step menu for this purpose. (Under the "Paste values" section ---- "values and source formatting")