SOLVED

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

Copper 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 (Copper Contributor)
Solution

Hi @bob hamblin 

 

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

 

Thanks

Tauqeer

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

Accepted Solutions
best response confirmed by bob hamblin (Copper Contributor)
Solution

Hi @bob hamblin 

 

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

 

Thanks

Tauqeer

View solution in original post