View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers Mike Rogers is offline
external usenet poster
 
Posts: 194
Default How do I apply formula to entire column

Tools-Options- on the veiw tab deselect "Zero Values"

Mike Rogers

"Stephan" wrote:

When I apply the formula to the entire column (a running total that is
updated everyday) "0" appear in all the ensuing cells that have not yet been
used. I would like to be able to apply the formula to current and future
entries without Exel placing those "0" in the cells not yet used. Does that
make any sense?
Thanks
Stephan