View Single Post
  #3   Report Post  
Old August 13th 08, 04:43 AM posted to microsoft.public.excel.worksheet.functions
ManhattanRebel ManhattanRebel is offline
external usenet poster
First recorded activity by ExcelBanter: Nov 2007
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