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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top