deleting blank rows

[KRK]

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

 

[Eduardo]

Hi,
Look at CPearson web

http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

if this helps please click yes

 

[Per Jessen]

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]

Thanks, this works nicely

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