Prev: using a time format in a count function
Next: Deleting Style 1 not found
From: Jeff on 6 May 2010 20:18
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.
From: Dave Peterson on 6 May 2010 20:34
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.

Jeff wrote:
>
> 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.

--

Dave Peterson
 | 
Pages: 1
Prev: using a time format in a count function
Next: Deleting Style 1 not found