View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default how do i copy just the data and not the formula in a cell?

Use "Paste Special" instead of "Paste". You'll then have an option to select
just "Values".

HTH,
Elkar


"Holden Caulfield" wrote:

I want to copy just the results of formulas in a series of cells and not the
formulas. that is i want to copy the values in cells.