Removing blank lines

[Timeferret]

I have been deleting numerous lines of my database, but I am left with
blank spaces.

Is there a way inwhich all the blank spaces, which there are hundreds,
can be removed by one click, with the following lines underneath
filling each space?


Thank you

 

[Bob Phillips]

Filter the data (Data>Filter>Autofilter), select blanks, and delete all
visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[David McRitchie]

It would be faster to fix the entire workbook at once, save the workbook
after running the DeleteUnused macro found within
Answers to Frequently Asked Questions about Microsoft Excel
http://www.contextures.com/xlfaqApp.html#unsed

which will remove the enpty rows and columns after the end of your actual data.