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

Maybe DataFilterAutofilterClick on a drop-down arrow and select Non-Blanks
from the options.


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 19:38:02 -0700, Hamid
wrote:

How can we instruct excel to show nonblanks in a cloumn of data?