I know there is a way of doing this, but I can not find it.

I have a spread sheet that is about 260 ROWS tall. The book is divided
into chunks of 16 rows with information above and summary data at the
bottom making about 20 rows in each block.
Depending on the block there may only 4 entries or 16.

How do I hide the rows that have nothing but "" in column E ?

Thanks in advance

Matthew Harrison

Ps I checked the mighty Chip's site could not find it (it is probably
there somewhere)

Maybe you can apply data|filter|autofilter to column E.

Then filter to show the non-blanks in that column.

Matthew wrote:

I know there is a way of doing this, but I can not find it.

I have a spread sheet that is about 260 ROWS tall. The book is divided
into chunks of 16 rows with information above and summary data at the
bottom making about 20 rows in each block.
Depending on the block there may only 4 entries or 16.

How do I hide the rows that have nothing but "" in column E ?

Thanks in advance

Matthew Harrison

Ps I checked the mighty Chip's site could not find it (it is probably
there somewhere)

--

Dave Peterson