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

Thank you..that works

"Teethless mama" wrote:

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