Forum Discussion

bob hamblin's avatar
bob hamblin
Copper Contributor
Dec 13, 2021
Solved

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

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

excel

3 Replies

Sort By
  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Dec 13, 2021

    Hi bob hamblin 

     

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

     

    Thanks

    Tauqeer

    • bob hamblin's avatar
      bob hamblin
      Copper Contributor
      Dec 19, 2021
      This gets me to the last row with data, not the next blank row. Maybe it’s just not possible. Thanks for the ideas.
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 13, 2021

    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.

Resources