show nonblanks

G

Gord Dibben

Please provide more detail of what you need Excel to do.

Maybe Data>Filter>Autofilter>Click on a drop-down arrow and select Non-Blanks
from the options.


Gord Dibben MS Excel MVP
 
Top