Hide a row based on one cell's condition

G

Guest

Is it possible to hide a row based on a condition?
For example...if I have dollar amounts in cells A1, B1, and C1....and I want
to hide any rows where the amount in the first cell is 0, can I?
 
D

Dave Peterson

I think the easiest way is to apply Data|Filter|Autofilter to that range.

Then you can filter to show values in that column that are greater than
(different from???) 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 Rows If Condition True 2
Creating a function to auto hide rows 1
Hide cell values based on a condition in another cell 1
Hide columns based on row values 2
hide row based on cell value 2
Hiding/Exposing Rows based on a cell value 10
Condition based on cell colour 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top