How to delete at once empty columns in a table?

C

capxc

How do I delete empty columns here and there in a table.
Can they be deleted at once?
If not, how does one delete them one by one?
 
W

Wigi

You can select an entire column, and in the statusbar to the right you can
ask for a COUNT of the cells in the selection (column).

If the result is 0, delete the column.

Or put this COUNTA function in a cell outside that column.

You can also select cells, hit F5, choose Special..., then Blanks to get the
blank cells in a range. That could speed things up a bit.
 
Top