deleting blank rows

  • Thread starter Thread starter KRK
  • Start date Start date
K

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
 
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
 
Thanks, this works nicely

K


Per Jessen said:
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
Click to expand...
 
Back
Top