Spaced-OoooO-Out
   


About

Dr Mike J Smith

Plymouth University

Personal Webpage

Email me
T:+44 (0)207 099 2817

Mike Smith


RSS FeedRSS Feed


Categories



Links






Calendar

March
M T W T F S S
   
30    


       

Excel: deleting blank rows

Thu, 30 Mar 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!

[/computing] permanent link



Comments

Add Comment
(all comments will be moderated)

Comments are closed for this story.