Hello,

I know how to hide a row or rows, but is there a way of automatically hiding
rows that contains no data ?

Thanks

K

You can hide blank rows using Autofilter but that would not be "automatic".

Automatic usually means VBA.

Do you want to go that route?




On Fri, 8 Apr 2011 13:48:43 +0100, "dido22" wrote:

Hello,

I know how to hide a row or rows, but is there a way of automatically hiding
rows that contains no data ?

Thanks

K

Too fast on the trigger<g

Give us an idea of what you want hidden and what would be thr triggering event.

i.e. data entry in a cell or cells?

Calculated value(s) reach a certain point?

A selection is made?


Gord Dibben MS Excel MVP

On Fri, 08 Apr 2011 08:18:53 -0700, Gord Dibben wrote:

You can hide blank rows using Autofilter but that would not be "automatic".

Automatic usually means VBA.

Do you want to go that route?




On Fri, 8 Apr 2011 13:48:43 +0100, "dido22" wrote:

Hello,

I know how to hide a row or rows, but is there a way of automatically hiding
rows that contains no data ?

Thanks

K