copy/paste vaules, not formulas

[jeremy via OfficeKB.com]

Is there an easier way to copy and paste the values of a cell without using
notepad? When i paste directly to new column the formulas get copied--i
only want to paste the final values...
Makes sense?
Jeremy

 

[JE McGimpsey]

Copy. Choose Edit/Paste Special. Select the Values radio button. Click
OK.

 

[rae820]

ok, so when you paste to a new column, go to edit---paste special...
then click in the button values!

that should work!

 

[jeremy via OfficeKB.com]

JE
Thanks

 

[jeremy via OfficeKB.com]

rae
thanks

 

[David McRitchie]

Hi Jeremy,
see http://www.mvps.org/dmcritchie/excel/paste.htm#withoutformatting
for five methods more detail on the above page.
1) paste to formula bar, 2) use notepad, 3) Edit, Paste Special, values,
4) use Steve Miller's "Pure Text", 5) use a macro