Excel: How to Move to First or Last Row in a List
This is a common problem faced when you are dealing with a large list. You are currently in the beginning of the list and quickly want to go to the last record just to check on the total number of records available. You can simply scroll down the list but that’s not a very efficient way and can take some time if the list is long.
A simple trick is to press CTRL + Down. This will take you to the last used cell in the active column. In case of a list, it will take you to the last record. Similarly, press CTRL + Up to go to the first used cell in the active column.