You can't, the closest you would get would be to use a filter, otherwise you
would need VBA
There is another way using conditional formatting but it will still print
that row albeit with invisible
text

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"haloprod" <haloprod@discussions.microsoft.com> wrote in message
news:DB5511AA-65D3-40DF-9845-016586809E45@microsoft.com...
> excel 2003 how do i omit a row from printing based on a value i put in a
> column?