Deleting Blank cells

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Hi all

Within my worksheet, I have column that some of the cells
have data in them but some of them are blank, e.g. first
cell has some data but second cell hasn't and third cell
has.
Is there any function that would get rid of the blank cell
and just give me the ones with data in them?

Thanks
Bruce
 
Select the whole range of data and do Edit / Go To Special / Blanks. You now
have a choice depending on whether youw ant to delete JUST those blank cells, or
you want to delete the ENTIRE row for each of those blanks cells. If the former
then just Edit / Delete / Shift cells up, or if the latter then hit / Edit /
Delete / Entire row.
 
Ken,

I don't think I explained my self very good.
Let's say I have a list of part number on the first column
and on next columns I have information about those parts.
The last column is formula which regarding all the
information would give you a value. This value could be
nothing or some number. What I want to do is, in some
other worksheet, I get only part number of parts that have
value and leave out the ones that dont have value.

I have tried filter but that would update it automatically.

Thanks
Bruce

well i dont think
 
I have tried filter but that would update it automatically.

That bit's confusing me. You can apply an autofilter to the sheet you currently
have to do this, or do you specifically want it on another sheet. Either way,
do you want it to update automatically or not?
 
Sorry mate, having a bad day.

anyway i ment it wouldnt update it. so if i change any
information of a part, and that part get value or loose
that value. you have to choose Non blank on autofilter
again to update the list. i want it to update the list
automatically.

cheers
 
Back
Top