How to quickly go to the last row?

In this Excel tutorial lesson, I will guide you through the different ways to quickly get to the last row of Excel.

Last row

We can jump to the last row of filled data row in Excel by choosing the first or any filled cell in that row and clicking Ctrl + Down arrow key.

Example.

Selecting the first cell of Row1:

Select First Cell

After clicking the Ctrl + Down arrow key:

Click CTRL Down

It selects the last row, which is cell A11. This is a quick and convenient way to navigate to the last row in your Excel sheet, and it saves you from having to manually scroll through the entire spreadsheet to find the last row.

Last column

We can go to the last column of filled data column in Excel by choosing the first cell in that row and clicking Ctrl + Right arrow key.

Example.

Selecting the first cell of Row1:

Click CTRL RIGHT

After clicking Ctrl + Right arrow key:

After Clicking CTRL Right

It selects the last filled column, which is Cell C1.

Last column and row

By clicking Ctrl + End keys, you can jump to the last filled row and the last filled column together.

Selecting the first cell:

CTRL END

After clicking Ctrl + End:

after clicking CTRL END

VBA code

We can also use VBA code to select the last row of a cell, which is the most used part in any VBA code, as shown in the following code:

LastRowSelected = Activesheet.range(“A65000”).end(xlup).row

In this, the variable LastRowSelected will have the value of the last filled row, which is 11 in this case. You can use this macro example as shown in the below attached sheet also:

See also  How to Shuffle in Excel

Sub macro1()
LastRowSelected =
ActiveSheet.Range(“A65000”).
End(xlUp).Row
MsgBox LastRowSelected
End Sub

VBA LastRowSelected macro

Please find the attached file with the required code.