Hi Landa,

As far as I know it it only possible to hide/unhide or group columns or rows
in excel,
when you think about it it would basically be impossible to hide seperate
cells, for example, if I have an empty cell in column A, row 5, and I would
hide that cell, cell B5 would have to shift into cell A5, and cause a lot of
problems if you use cell references in formulas. I could be wrong, but I've
never heard of that...

Regards, Nico from the Netherlands

"Landa" wrote:

I have an excel table which contains hundreds of rows with variable columns
(e.g. row 1 has data in 5 cells, row 2 has data in 10 cells etc). There are
blank cells in some of the rows and they are not in a regular pattern. Is
there any way I can remove all those blank cells?

Thanks a lot in advance!