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