Hi,
Highlight rows 15 to 29, right click in the mouse Hide

if this was helpful please click yes, thanks

"pen" wrote:

In Excel 2003 I have a simple sum formula that is copied down the column.
When I type in a value, it displays the answer all the way down the column.
Is there a way to hide the answer in only the cells that are for rows where
no value is typed in?

For example: Cell B14 has the value 2 in it, and cells C14 - C29 have the
total 2 displayed. I just want the total of 2 displayed in only C14 and
hidden from C15 - C29.

Is this possible?