Hiding blank rows

I have a spreadsheet with columns, first name, last name, home phone,
business phone and cell phone. When I don't have phone information in any of
the three columns I would like that column to be hidden or deleted. Can I do
this in some automated fashion? Thanks. Michael

try adding a column
in that column put something like
=if(counta(b2-d2)>0,"",1)
and use autofilter to hide the 1s


"mlkpied" wrote:

> I have a spreadsheet with columns, first name, last name, home phone,
> business phone and cell phone. When I don't have phone information in any of
> the three columns I would like that column to be hidden or deleted. Can I do
> this in some automated fashion? Thanks. Michael