View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default hiding all cells that don’t haveany text

It sounds like you're hiding rows that are empty.

If you can pick out a column that is always empty if the row is empty, you
could:

Select your range (A1:E62)
data|filter|autofilter (in xl2003 menus)
filter to show the non-blanks in that key column

Misho wrote:

I have a worksheet that have text from A to E & form 1 to 62.

I usually select all the rows after my data then right click then Hide and
the same I do for col.

Is there a way that I can do it faster?


--

Dave Peterson