To remove or delete blank columns in an Excel table is fairly straight forward and easy. Just select the column or press Ctrl to select multiple columns to delete. However if there might be a LOT of columns and they might be non consecutive (i.e., not next to each other). You may have received this table from a system, person or some other source that has just not thought about you as a end user (the table has twenty or more empty columns EVERYWHERE) and it's going to be a lot of clicking.
There are a couple a ways this could be solved and it doesn't involved writing VBA. There is a little bit of M code to write in one of the examples, but it is not that much considered its usefulness. See the video now to see how it's done.
No comments:
Post a Comment