How To Remove Blanks In Excel?

Select the range with blanks

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 use Find & Select > Go To Special > Blanks

Or use Power Query to remove blank rows

Or use formulas like FILTER to exclude blanks