How to Remove Empty or Blank Cells in Excel 2016

In this tutorial, we’re going to show you how to remove empty or blank cells in Excel 2016.


To get started, open the drop-down Find & Select under the Home tab and click Go To Special…

Remove Empty or Blank Cells in Excel 2016

Select Blanks and hit OK.

Remove Empty or Blank Cells in Excel 2016

Now that all the blank cells are selected, you can go and hit Delete.

Remove Empty or Blank Cells in Excel 2016

Choose the option that fits your worksheet best and hit OK.

Remove Empty or Blank Cells in Excel 2016

The results may not be ideal, but it will at least give you a starting point. You can select only certain groups of cells next time manually, or delete all blanks and manually move elements around to suit your needs.
To bring of the Special… menu, you may also hit F5 on the keyboard and click Special… from the Go To menu that comes up.

Remove Empty or Blank Cells in Excel 2016