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
|