Auto-suppress rows with all zero values

A

Ashish Mathur

Hi,

Highlight the range (give a heaing to the range and bold
face it)

1. Data > Filter > Auto Filter

2. Click on the down arrow now which appears on the
headin of the data

3. Custom > Does not Equal 0

Hope this helps

Regards,

Ashish Mathur
 
Top