Delete Blank Rows

[welchww]

I need to delete blank rows. I have a sheet with column headers. If I select F5, special, blanks, then it only highlights the columns with no data, not the rows. How do I highlight the rows with blank data? Thanks, WW

 

[Hui]

Welchww


This is one of the most asked questions at the Chandoo.org Forums


If you use the Google Custom search box (Top right of this and every page at Chandoo.org) I am sure you'll find an answer that helps you.

 

[welchww]

I did, every answer seems to suggest using the approach I detailed using F5. One approach was to filter, but this doesn't let me delete them. Would you mind linking an answer, I have looked for about an hour. WW

 

[Luke M]

Once you have the cells selected, if you right-click, delete, you can then select the option to delete the entire row.

 

[welchww]

The cells that highlight are in the blank columns, not the blank rows.

 

[DaveTurton]

Filter for blanks - highlight rows - right click - delete

 

[welchww]

That worked, thanks, WW

 

[bobhc]

Good day welchww


Select the cells in one column from the top of your list to the bottom.

Make sure that all the blank cells in this selected range are the rows you want to delete.

Press the F5 key on your keyboard (or select Edit, Goto).

Click the Special... button.

Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.

Now right click in one empty row cell and choose, Delete, select the “shift rows up” from the option and click OK.

 

[welchww]

I figured out my problem, my cells are not blank, they are "" which is text due to an if then formula and then pasting as values. So my question becomes how do you have make the result a blank in an if then statement. WW

 

[SirJB7]

Hi, welchww!

Since the cell has content (a formula, no matter it displays a blank "" or anything) it's not empty so it won't be blank anyhow. Instead of using ISBLANK(A1) function change your test condition to A1="".

Regards!

 

[Luke M]

For purposes of just deleting data, I would suggest changing the IF formula you have now to create an error instead of "". Then, you can use the Special Cells - Formulas, errors, to select the cells in question.