Hi Bernie,
The process worked fine up to the rt-click part.
It only gives me the option to delete entire row or entire column. Either
option deletes information

"Bernie Deitrick" wrote:

I guess I read it too quickly - after using the go to part, rt-click and choose Delete /
Shift-cells up OR Shift cells left then press OK.

HTH,
Bernie
MS Excel MVP


What if C10 is blank but D10 has data? How are you planning on
deleting just blank cells if the whole row isn't blank?

Damien,

Select columns, then use Edit / Go To... Special Blanks OK, then Rt-Click any of the blank
cells, then choose Delete / Entire Row OK.

HTH,
Bernie
MS Excel MVP

"DamienO" wrote in message

...

I have sheets with data in adjoining columns. Not every cell has data. I want
to removed all the empty cells and leave only a full page of data. At the
moment the only way I can think of is advance filtering for non-blanks but I
have to do this for each individual column which is time consuming (multiple
sheets etc)
Alternatively would there be a way of filtering all the columns for
specific words and returning only cells that meet certain criteria