Excel: deleting blank rows

Thursday, 30 March, 2017

One of those great tips that just makes life easier… you have 100,000 records in an Excel spreadsheet that you’ve just pulled from a live database and it’s ended up with some blank rows in it, scattered throughout. How do you delete them easily?? With this tip using (believe it or not) the “Go To” dialog in Excel! And, copied verbatim:

1) Select the cells in one column from the top of your list to the bottom;

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

3) Press the F5 key on your keyboard;

4) On the Go To dialog, click the Special… button;

5) Choose the Blanks option and click OK. This will select all blank cells in the range you had previously selected;

6) Right click on one of the selected cells, select Delete, Entire Row and click OK.

Voila!

Add comment

Fill out the form below to add your own comments