View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default F5 function for zeroes?

Another option would be to edit|replace 0 with #n/a

Then you could use the F5 stuff to clear the errors.

Lee Harris wrote:

Can you do a similar trick to F5-Special- etc to select all 0 values in a
range and then delete them, like you can with #n/a and errors


--

Dave Peterson