Hide row if cell = 0

  • Thread starter Thread starter NilesTimothyJ
  • Start date Start date
N

NilesTimothyJ

Ok I've a list of entries with values

essentially looks like this

ID Description Value

What i need is to hide the row if the value = 0

I'm pulling this data from a list, so essentially each cell is already
a function set to equal to another sheet ( I could hard write this in)

I'm using Excel 2007 too if it matters
 
I'd use Data|Filter|autofilter.

Then use a custom filter of not equal to 0.
 
You must log in or register to reply here.

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

Creating a function to auto hide rows 1
Hide Rows If Condition True 2
Row Hide Or 0 value 2
Excel EXCEL - using a date dependant formula to hide rows 3
hide row based on cell value 2
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Hiding Rows 5
Hide columns based on row values 2

Back
Top