Excel Column

[red14red]

Basic question. I have a huge database in Excel with 8000 names in column A.
Some of these columns are blank. I need to line up all the blank cells and
delte them thus leaving all of the cells with values. Is there a way to do
this other than manually deleting the blank cells. Thanks in advance.

 

[Sean Timmons]

When you say delete them, are you attempting to delete the entire row? If so,
highlight your sheet, then Data - Filter - Autofilter. Pick (blanks) from
column A, highlight your resulting rows Edit - Delete.

 

[muddan madhu]

select the column A | press F5 | click special | choose blanks | ok |
right click on the col A | delete | choose shift cells up | ok

 

[red14red]

thanks sean, worked ike a charm, one more question if you have the time. how
do I delete cells that are duplicates? is there a way to do this?

 

[Sean Timmons]

Depending on what you want to do...


Is the entire row a duplicate?

If so.. Data - Filter - Advanced Filter

Highlight the entire table

Copy to another location

Pick your copy to location

Unique records only

Will delete full dups.

If only column A is a dup then, depends on number of columns.

Can use a pivot table, drop the Header in Row fields to get only unique
records. Can use Column fields to pivot the data and data fields to sum up,
average, etc.

 

[Gord Dibben]

Data>Filter>Advanced Filter.

Check Unique Records Only and Copy to another range


Gord Dibben MS Excel MVP