View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default How can I remove a formula from an entire column?

Select your range right click Copy right click Paste Special Values
OK out


"ManhattanRebel" wrote:

Using F2 and F9, I am able to remove a formula from a cell, but how can I do
it for an entire column of numbers? Tks, mr