How To Remove Blank Cells In Excel?

Select the range of cells

Press Ctrl+G or F5

Click Special

Select Blanks

Click OK

Right-click any selected blank cell

Choose Delete

Select Shift cells up or Shift cells left

Click OK

Or use Filter to hide blanks

Or sort the column to move blanks to the bottom

Or use Go To Special and delete entire blank rows or columns

Or use Power Query to remove blank rows

Or use a formula to filter out blanks and paste values back