Selecting the Cell in the First Row in a Column in Excel

Two shortcuts

There is a keyboard shortcut to select the first column in a row, but as far as I know there is no shortcut for the first row in a column.

You can press the Home key to select the first column in the current row.

Selecting the first row in the current column is not so easy. Here are a couple of ways.

Ctrl key

Hold Ctrl then press Space Bar then press the full stop . then press the Up arrow. You can release the Ctrl key after the full stop.

F5 function key

Press the F5 function key then type in the cell reference eg d1 and then press Enter. You can do this to select any cell in the sheet.

 

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

4 thoughts on “Selecting the Cell in the First Row in a Column in Excel