Excel Column

R

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

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

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
 
R

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?
 
S

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

Gord Dibben

Data>Filter>Advanced Filter.

Check Unique Records Only and Copy to another range


Gord Dibben MS Excel MVP
 
Top