Delete empty cells

Modified on Sat, 14 Nov at 9:48 AM

Delete empty cells is a feature of the Power-user add-in for Excel that removes all the empty cells from a range in one click and stacks the remaining cells up or to the left. It is a quick way to clean data before analyzing it, without sorting or filtering by hand.

In short

  • Where: Delete empty cells in the Power-user tab of Excel
  • What you get: a range with no blank cells, the other cells stacked up or to the left

How to delete empty cells in Excel

  1. In Excel, on the Power-user tab, click Delete empty cells.
  2. In the dialog box, select the range to clean and validate.
  3. Choose whether to stack the other cells up or to the left, and click OK.

Delete empty cells dialog box: stack the other cells up or to the left

Delete empty cells dialog box: stack the other cells up or to the left

Deleting the empty cells of a range in Excel with Power-user

Deleting the empty cells of a range in Excel with Power-user

Stack the cells up or to the left

OptionResult
UpThe cells below each empty cell move up: the data of each column is stacked vertically.
LeftThe cells to the right of each empty cell move left: the data of each row is stacked horizontally.
See also: other Power-user tools to prepare your Excel data, such as UnPivot table to turn a crosstab table into a database, and the advanced functions.

Frequently asked questions about deleting empty cells in Excel

How do I delete all empty cells in an Excel range?

With the Power-user add-in, click Delete empty cells in the Power-user tab of Excel, select the range, choose to stack the other cells up or to the left and click OK. All the empty cells of the range are removed.

How do I remove blank cells and shift the data up in Excel?

In Power-user Delete empty cells, choose to stack the cells up: in each column, the cells below each blank cell move up.

Can I remove blank cells and shift the data to the left?

Yes. In Power-user Delete empty cells, choose to stack the cells to the left: in each row, the cells to the right of each blank cell move left.

Does Delete empty cells work on a whole sheet?

Power-user Delete empty cells works on the range you select in its dialog box. Select the whole used range to clean a full table.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article