hiding rows

[dido22]

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

 

[Gord Dibben]

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

Automatic usually means VBA.

Do you want to go that route?

 

[Gord Dibben]

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