Check if the cell being referred to has data. For example

=IF(A10="","",A10*5)

when A10 is empty, you will see nothing.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Donald" wrote in
message ...

How does one hide formulas in cell that are not yet being used, another
words if i copy a formula down several rows, but only enter info each
day when i go to print the report for that day it shows all of the info
plus the next formulas.


--
Donald
------------------------------------------------------------------------
Donald's Profile:
http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310