delete all empty cells in a range

[Gary]

How can I delete all empty cells from a range of 5000 cells?

 

[Dave F]

Select the range, then Edit--Goto--Blanks

Click OK and all blanks will be selected. Then Edit--Delete.

Dave

 

[Gord Dibben]

Select the range then F5>Special>Blanks>OK

Edit>Delete>Shit Up or Left


Gord Dibben MS Excel MVP