IF/Hide Q.

  • Thread starter Jonathan Morningstar
  • Start date
J

Jonathan Morningstar

In my spread sheet, I have a fields called Amount Due. How do I hide all
the rows that the Amount Due is zero?

You help and knowledge is greatly appreciated.

Respectfully,

Jonathan Morningstar
Greenville South Carolina USA
 
D

Dave Peterson

I would apply Data|Filter|autofilter to that column.
Then use the dropdown arrow, choose custom, not equal to 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

Print Tasks Outlook 2007 Q. 2
Password EVERY TIME?! 1
Show Only Fields Needed 0
Possible to do without a Macro? 1
Hide rows using IF 1
Hide drop downs 1
Hide multiple rows when particular cell is zero 17
Hide/unhide 4

Top