hide a row if the values in the cell are zero

D

Dave Peterson

I think the easiest way to do this is to select your range and apply
Data|filter|Autofilter.

Then you can use the dropdown and do: does not equal 0.
 

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

Similar Threads

Hide zero values 2
zero values 5
How to display zero value in blank fields of Cross Tab query 0
Loop through a range of rows and hide based on conditions 3
Code to hide rows if cell in another WS is ="No" 11
Newbie Help - IF Yes No Function 0
radio buttons in XL2003 2
Hide rows in table based on 1 empty cel of the same row. 1

Top