How to delete at once empty columns in a table?
 

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?
--
capxc

How to delete at once empty columns in a table?
 

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.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"capxc" wrote:

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?
--
capxc