This only makes sense when your columns (or rows) are completely independent from one another.
Single Column - GoToSpecial
Select the cells
Ctrl + Shift + End
This will extend the selection from the current cells to the last used cell.
Once this range has been selected hold down the Shift key and press the Left arrow key until you have a single column selected.
(Home tab, Editing Group)(Find & Select - GoTo Special)
Right mouse click and press Delete
This will display the Delete dialog box
Choose "Shift Cells Up" and press OK
The Undo (Ctrl + Z) can be used if you want to put the blank cells back.
Single Column - Array Formula
An alternative to actually removing the blank cells is to create another list without the blanks.
There are several ways you can do this.
One way is to use an Array Formula.
The steps would be exactly the same as the single column
Instead of selecting one column you can select multiple columns.
These columns do not have to be next to one another (contiguous)
From A Table
You can only delete entire columns from a table, not individual cells.
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext