How can I delete all empty cells from a range of 5000 cells?
D Dave F Feb 8, 2007 #2 Select the range, then Edit--Goto--Blanks Click OK and all blanks will be selected. Then Edit--Delete. Dave
Select the range, then Edit--Goto--Blanks Click OK and all blanks will be selected. Then Edit--Delete. Dave
G Gord Dibben Feb 8, 2007 #3 Select the range then F5>Special>Blanks>OK Edit>Delete>Shit Up or Left Gord Dibben MS Excel MVP
