delete empy rows

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

Try this on a *spare* copy ..

Select col C
Press F5 > Special > Blanks > OK
Right-click on the selection > Delete > Entire row > OK
 
Hi,
I have a sheet with 3000 lines, I am using only thre coomns A, B, C
How can I delete all rows that has empty cells in colomn C

i.e. row 5 contains Sam in colomn A , 2 in colomns B , nothing in colomn
C. I want to delete this row

row 6 contains 3 in colomn A, nothing in colomns B, 34 in colomn C.
I want to keep this row.

can this be done
Khalil
 
I have a sheet with 3000 lines, I am using only thre coomns A, B, C
How can I delete all rows that has empty cells in colomn C

i.e. row 5 contains Sam in colomn A , 2 in colomns B , nothing in colomn
C. I want to delete this row

row 6 contains 3 in colomn A, nothing in colomns B, 34 in colomn C.
I want to keep this row.
Click to expand...

Insert a new column.
Use auto fill to number them from 1 to 3000.
Sort on the column that used to be C
Rows with nothing in your old C column will be grouped together. Delete
them.
Re sort on your added column.

Jordon
 
Just do one thing

1. insert a row
2. give it heading as per the values in the columns,
3. Apply filter with BLANKS in column C
4. Select the rows with Shift+Space & downarrow while holding the shift.
5. Right click & delete.

That's it
 
Back
Top