Removing Blanks

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)
SS
Select Blanks
Right mouse click and press Delete
This will display the Delete dialog box
SS
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.




Multiple Columns

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.



Horizontal List




© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext