How to delete blank rows at one time in a long excel spreadsheet?

L

lkurokawa

I have a list of over 6,000 email addresses that I imported into an excel
spreadsheet and the list has many, many blank rows. I need to delete these
blank rows in one command rather than spend an hour going through and
selecting them one row at a time to delete. Is there a command in excel that
can do this? I am using MS Excel 2003 version.
 
T

Teethless mama

Select your range
Hit F5 > Special > select Blanks > OK > Edit > Delete > shift cells up > OK
out
 
G

Gord Dibben

Select a column.

F5>Special>Blanks>OK>Edit>Delete>Entire Rows


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Integrating information from Word to Excel (not mail merge) 1
Insert name and adress from a list in a word document 1
Function in Excel to count and list number of entries of text valuesin a row. 2
Merging from an Excel file with graphics 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
need to input alternate blank rows in spreadsheet 5
how to delet the blank rows in whole sheet at a time 1

Top