Hiding Rows

chadm · Apr 15th, 2002, 03:27 PM

I am Excel impaired.
Is there a simple formula to hide a row? I do not know how to use Macros.

Basically, if a cell is over 99, I want that row to be hidden.

Thanks for any suggestions.

Asala42 · Apr 15th, 2002, 03:31 PM

Hiya,

I don't know of a formula that will hide a row. But you could use a simple autofilter (dataautofilter) to only show entries <99.

Hope that helps,
Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 03:27 PM	#1
chadm New Member Join Date: Apr 2002 Posts: 45	I am Excel impaired. Is there a simple formula to hide a row? I do not know how to use Macros. Basically, if a cell is over 99, I want that row to be hidden. Thanks for any suggestions.

Apr 15th, 2002, 03:31 PM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Hiya, I don't know of a formula that will hide a row. But you could use a simple autofilter (dataautofilter) to only show entries <99. Hope that helps, Adam