How to remove blank cells in excel


Staff member
How to remove blank cells in Excel
  1. Select the range where you want to remove blanks. ...
  2. Press F5 and click Special… . ...
  3. In the Go To Special dialog box, select Blanks and click OK. ...
  4. Right-click any of the selected blanks, and choose Delete… from the context menu:
  5. Depending on the layout of your data, choose to shift cells left or shift cells up, and click OK.