I'd like for Excel to automaticalliy hide a row if the value in a given cell is equal to zero.
M Maxwell Sprinkler May 31, 2005 #1 I'd like for Excel to automaticalliy hide a row if the value in a given cell is equal to zero.
D Dave Peterson Jun 1, 2005 #2 Can you apply Data|Filter|Autofilter and do a custom filter of not equal to 0? (Not quite automatic, but pretty darn effective.)
Can you apply Data|Filter|Autofilter and do a custom filter of not equal to 0? (Not quite automatic, but pretty darn effective.)
