Is there a way to conditionally hide a row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like for Excel to automaticalliy hide a row if the value in a given cell
is equal to zero.
 
Can you apply Data|Filter|Autofilter
and do a custom filter of not equal to 0?

(Not quite automatic, but pretty darn effective.)
 
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

Conditionally hiding rows 1
Macro to hide rows with zero in specifc column range 2
Code to Hide Rows 7
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Hiding rows 1
Macro to hide rows with zero values in columns 2
Hide and Show Rows based on Cell Value 2
hiding or showing rows based on a cell value 6

Back
Top