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
In this article
How to delete empty cells in Excel
- In Excel, on the Power-user tab, click Delete empty cells.
- In the dialog box, select the range to clean and validate.
- 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

Deleting the empty cells of a range in Excel with Power-user
Stack the cells up or to the left
| Option | Result |
|---|---|
| Up | The cells below each empty cell move up: the data of each column is stacked vertically. |
| Left | The cells to the right of each empty cell move left: the data of each row is stacked horizontally. |
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
Feedback sent
We appreciate your effort and will try to fix the article