Delete empty cells

Modified on Thu, 22 Sep 2022 at 05:10 PM

In order to clean your Excel data, you may have to delete all empty cells from a range. This is something that Power-user can do for you.

Power-user l Delete empty cells

From the Power-user ribbon in Excel, click Delete empty cells.
From the dialog box that opens, select the range from which you want to remove empty cells, and validate.
Select if you would like to stack all the other cells up or left, and click OK.
That's it.

Power-user l Delete empty cells