Delete rows with empty cells in columns B&C

Hi,

I have a huge spreadsheet that needs to have all rows with empty cells in
both columns B and C deleted. I was going through it line by line, but there
has got to be a better way. My knowledge of Excel and all of its features is
very limited. Any help would be appreciated.

Thank You,
Richard

This is one of the standard features of ASAP Utilities, available at
www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Richard" wrote:

> Hi,
>
> I have a huge spreadsheet that needs to have all rows with empty cells in
> both columns B and C deleted. I was going through it line by line, but there
> has got to be a better way. My knowledge of Excel and all of its features is
> very limited. Any help would be appreciated.
>
> Thank You,
> Richard

Do I have to pay for these utilities?

"CLR" wrote:

> This is one of the standard features of ASAP Utilities, available at
> www.asap-utilities.com
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Richard" wrote:
>
> > Hi,
> >
> > I have a huge spreadsheet that needs to have all rows with empty cells in
> > both columns B and C deleted. I was going through it line by line, but there
> > has got to be a better way. My knowledge of Excel and all of its features is
> > very limited. Any help would be appreciated.
> >
> > Thank You,
> > Richard

No, ASAP Utilities are free, sorry I forgot to mention that fact in my
post.....

Vaya con Dios,
Chuck, CABGx3


"Richard" <[email protected]> wrote in message
news:[email protected]...
> Do I have to pay for these utilities?
>
> "CLR" wrote:
>
> > This is one of the standard features of ASAP Utilities, available at
> > www.asap-utilities.com
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Richard" wrote:
> >
> > > Hi,
> > >
> > > I have a huge spreadsheet that needs to have all rows with empty cells
in
> > > both columns B and C deleted. I was going through it line by line, but
there
> > > has got to be a better way. My knowledge of Excel and all of its
features is
> > > very limited. Any help would be appreciated.
> > >
> > > Thank You,
> > > Richard