How can I hide rows 21 through 54 and Columns I through BP when the
entire row/column is either 0 or blank between I21 and BP54?

Thanks,
Lynn


--
lw new guest
------------------------------------------------------------------------
lw new guest's Profile: http://www.excelforum.com/member.php...o&userid=26418
View this thread: http://www.excelforum.com/showthread...hreadid=396901

An easy way to do this would be to use the auto filter feature,
Data-Filter-Auto Filter. Then within each filter choose "(NonBlanks)".

Does that help?
--
Regards,

Dave


"lw new guest" wrote:


How can I hide rows 21 through 54 and Columns I through BP when the
entire row/column is either 0 or blank between I21 and BP54?

Thanks,
Lynn


--
lw new guest
------------------------------------------------------------------------
lw new guest's Profile: http://www.excelforum.com/member.php...o&userid=26418
View this thread: http://www.excelforum.com/showthread...hreadid=396901

I tried that - but it is a rather large spreadsheet. I have to send
this out to several users who will input data. I want for them and me
to be able to click a toolbar button to make the entire column hide or
the entire row hide if there is a blank or a "0" in all the cells in
that column or row.


--
lw new guest
------------------------------------------------------------------------
lw new guest's Profile: http://www.excelforum.com/member.php...o&userid=26418
View this thread: http://www.excelforum.com/showthread...hreadid=396901