How to move to B column of the next blank row?

New Contributor

Is there a simple way I can quickly move to the next blank row in my excel sheet, specifically the B column?

3 Replies

@bob hamblin 

Press the End key, then the Down Arrow key. The next empty cell will below the cell where you end up.


Alternatively, select column B.

Press F5 to display the Go To dialog.

Click Special, then select Blanks, and click OK.

The cell you seek will be the first selected cell.

best response confirmed by bob hamblin (New Contributor)

Hi @bob hamblin 


By pressing Cltr + down arrow key you may quickly go to the next blank row.




This gets me to the last row with data, not the next blank row. Maybe it’s just not possible. Thanks for the ideas.