Hiding Rows
Hi,
Select A1 then
data|Filter|Autofilter
click the down arrow and rom the dropdown select 'Does not equal'
enter 0 (zero)
OK
Mike
"Graham Moore" wrote:
I have a cell that has 0 for a total and I want to hide the entire row that
cell is in. Expamle: if cell A1 is '0', I want to hide row 1. Any ideas
how I can do that. I am using excel 2003.
Thanks
Graham
|