copy/paste vaules, not formulas

  • Thread starter jeremy via OfficeKB.com
  • Start date
J

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
 
R

Ron de Bruin

Hi jeremy

Copy the cells
Right click on the target cell
Choose Paste Special
Select Values
OK
 
Top