Spaced-OoooO-Out ::

I was doing some straight forward data management in Excel today and had gone through a long list of items and deleted a number of them….. you’re then left with a list of items with blanks in it! This is a familiar problem and many people end manually going through the list to remove them.

There are two simple solutions in this situation, both based around the idea that you want to create a selection of the data items you DO and DON’T want.

Select Blank Cells
(thanks to WikiHow for prompting this one)

1. Create a selection of the area that contains the empty rows you want to delete
2. Press Ctrl+G (GoTo)
3. Choose Advanced (or Special depending on version) and then select “Blanks” (this will select all the blanks in the column selected)
4. Right click on one of the selected cells and select “Delete”5. Choose “Delete entire row”

Sort Cells
1. Select the entire range of cells for your data (not just a single column)
2. Goto Data -> Sort and sort the column using any sort criteria (e.g. A to Z)3. Blank rows will be moved to the bottom of the sorted range