Hello,

I have a large worksheet with several hundred rows, and about 15 columns.
About 50% of the rows blank (but they are not evenly distributed).

I want to delete the blank rows. Can someone point me in the best direction
please? Should I use filters?

Thanks for all advice

K

Hi,
Look at CPearson web

http://www.cpearson.com/excel/deleti...eleteBlankRows

if this helps please click yes

"KRK" wrote:

Hello,

I have a large worksheet with several hundred rows, and about 15 columns.
About 50% of the rows blank (but they are not evenly distributed).

I want to delete the blank rows. Can someone point me in the best direction
please? Should I use filters?

Thanks for all advice

K

Hi K

Another way, if the entire row is blank.

Select the columns, Goto Edit Go To Special Select: Blanks OK
Right click on one of the selected cells Delete Entire Row OK

Hopes this helps.

Per

"KRK" skrev i meddelelsen
...
Hello,

I have a large worksheet with several hundred rows, and about 15 columns.
About 50% of the rows blank (but they are not evenly distributed).

I want to delete the blank rows. Can someone point me in the best
direction please? Should I use filters?

Thanks for all advice

K

Thanks, this works nicely

K


"Per Jessen" wrote in message
...
Hi K

Another way, if the entire row is blank.

Select the columns, Goto Edit Go To Special Select: Blanks OK
Right click on one of the selected cells Delete Entire Row OK

Hopes this helps.

Per

"KRK" skrev i meddelelsen
...
Hello,

I have a large worksheet with several hundred rows, and about 15 columns.
About 50% of the rows blank (but they are not evenly distributed).

I want to delete the blank rows. Can someone point me in the best
direction please? Should I use filters?

Thanks for all advice

K