Shortcut to jump to last non-empty row in range skipping empty rows

Solution 1:

As mentioned above in comments, CTRL+END will take you to the last cell in the worksheet.

If you want to go to the last cell in a column, AFAIK, you may need a macro as (which you noticed) CTRL+DOWN will stop at the first empty cell.

Put this macro in a module in your workbook, and you can then assign a keyboard shortcut to it and it'll select the last non-empty cell in the active column.

Sub gotoLastRow()
With ActiveSheet
    .Cells(.Rows.Count, ActiveCell.Column).End(xlUp).Select
End With
End Sub

Shortcut to jump to last non-empty row in range skipping empty rows

Solution 1:

Related

Recent Posts