Excel Column
 

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.

Excel Column
 

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.

"red14red" wrote:

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.

Excel Column
 

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


On Sep 26, 1:56*pm, red14red
wrote:
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.

Excel Column
 

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" wrote:

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.

"red14red" wrote:

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.

Excel Column
 

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.


"red14red" wrote:

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" wrote:

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.

"red14red" wrote:

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.

Excel Column
 

DataFilterAdvanced Filter.

Check Unique Records Only and Copy to another range


Gord Dibben MS Excel MVP

On Fri, 26 Sep 2008 11:54:22 -0700, red14red
wrote:

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" wrote:

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.

"red14red" wrote:

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.