In this article I will guide you, how to go to the last row of Excel quickly in different ways.
1. We can go to the last row of filled data row in excel by choosing the first/ any filled cell in that row and click Ctrl + Down arrow key. Example. Selecting first cell of Row1:
After clicking Ctrl + Down arrow key:
It selects the last row which is cell A11.
2. We can go to the last column of filled data column in Excel by choosing the first cell in that row and click Ctrl + Right arrow key.
Example. Selecting first cell of Row1:
After clicking Ctrl + Right arrow key:
It selects the last filled column which is Cell C1.
3. We can go to the last filled row and last filled column together by clicking Ctrl + End keys.
Selecting first cell:
After clicking Ctrl + End:
4. We can also use VBA code to select the last row of a cell , which is most used part in any VBA code as shown in 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:
LastRowSelected = ActiveSheet.Range("A65000").End(xlUp).Row MsgBox LastRowSelected End Sub
Please find the attached file with the required code.