Removing blank lines

T

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
 
B

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)
 
D

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.
 
Top