Hi Peter,

Have a look at "Outline a worksheet " and at "Group Ungroup" in help. This
feature could very well do exactly what you want and would enable you to
click between various hierarchical data levels revealing or hiding support
data.



Also, look to use the AutoFilter and Advanced Filters.



---
Regards,
Norman




"Peter" wrote in message
...
How complicated is it to create a macro to hide rows
conditioned upon a zero value in a particular column of
that row? Could a second condition also be added to test
for bold font type zeros to not be hidden? I have a VERY
large cost estimating spreadsheet with 2,000 rows of
items, and want to be able to hide rows that do not
apply. Summary rows are in bold type and I would like to
retain them, but hide all the detail. It takes forever
manually!.