| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete blank rows at one time in a long excel spreadsheet?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to delete blank rows at one time in a long excel spreadsheet?
Select your range
Hit F5 Special select Blanks OK Edit Delete shift cells up OK out "lkurokawa" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to delete blank rows at one time in a long excel spreadsheet?
Select a column.
F5SpecialBlanksOKEditDeleteEntire Rows Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 12:13:00 -0700, lkurokawa wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Long time to open spreadsheet (running Excel 2007) | Excel Discussion (Misc queries) | |||
| In Office 2000, How do I delete multiple blank rows at one time? | Excel Worksheet Functions | |||
| I want to delete multiple blank rows from a spreadsheet | New Users to Excel | |||
| how do you delete blank rows in a spreadsheet using an "if" funct | Excel Discussion (Misc queries) | |||
| How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
Linear Mode
