Is there a way to conditionally hide rows in Excel?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I would like to be able to conditonally hide row based upon a value in a
column of the spreadsheet.
I assume I would need to create a macro, but I'm nt real good with macros.

Can anyone help with this?

Thank you.
 
Select your range (don't let excel guess) and then use:

Data|Filter|Autofilter
(in xl2003 menus)

Then you'll be able to use the dropdown arrows in that first header row to show
just the values you want.

There's a custom option, too.
 
Back
Top