How to delete at once empty columns in a table?

  • Thread starter Thread starter capxc
  • Start date Start date
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top