| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Empty Rows | Excel Discussion (Misc queries) | |||
| Delete rows that are empty across columns | Excel Worksheet Functions | |||
| How do I delete multiple empty columns in Excel at one time? | Excel Discussion (Misc queries) | |||
| Delete rows with empty cells in columns B&C | Excel Discussion (Misc queries) | |||
| how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) | |||
Hybrid Mode
