How do I create a conditional formula that hides a complete row o.
 

How do I create a conditional formula that hides a complete row or rows if a
value = 0? I want the rows to disappear so that I can print out only the
information for rows that have information in them.

How do I create a conditional formula that hides a complete row o.
 

If you are going to use a formula it is not possible to hide, you can use
formatconditional formatting and use white fonts that won't be visible when
printing or you can use a custom format that does not show zeros
However it won't be the same as hiding rows since it will print a blank row,
only other option would be a macro

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Tom" wrote in message
...
How do I create a conditional formula that hides a complete row or rows if
a
value = 0? I want the rows to disappear so that I can print out only the
information for rows that have information in them.

How do I create a conditional formula that hides a complete ro
 

Thanks, Peo. Not the answer that I wanted to hear, but the correct answer
probably none the less.

If anyone else comes up with a solution, it would be great to hear.

Thanks, again.

Tom

"Peo Sjoblom" wrote:

If you are going to use a formula it is not possible to hide, you can use
formatconditional formatting and use white fonts that won't be visible when
printing or you can use a custom format that does not show zeros
However it won't be the same as hiding rows since it will print a blank row,
only other option would be a macro

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Tom" wrote in message
...
How do I create a conditional formula that hides a complete row or rows if
a
value = 0? I want the rows to disappear so that I can print out only the
information for rows that have information in them.

How do I create a conditional formula that hides a complete ro
 

Apply a filter to the column which contains your values which might
equal 0. To hide the rows, choose Custom Filter | Not Equal To 0
(zero). Then you can print out.

Hope this helps.

Pete