ajay87 AJ

Excel: removing blank cells and shifting the rest up

I've got a column of about 2000 names with random empty cells between them. Deleting them one by one takes forever. Is there a quick way to remove all the blanks so everything moves up?
remove blank cells
1

Leave A Reply

Log in to post an answer.

1 Answer

N
noraj Nov 04, 2026
ajay87
Select the column, Home > Find & Select > Go To Special > Blanks > OK. Every empty cell is now selected. Right click one of them > Delete > Shift cells up. Done in ten seconds for 2000 rows. If some cells look empty but hold a formula returning "", Go To Special won't catch them, in that case filter the column for blanks and delete the visible rows instead. On 365 you can also drop =FILTER(A2:A2001,A2:A2001"") in a new column.
Reply