Excel: How to Move to First or Last Row in a List
1 min read
Get full access to all Data Science, Machine Learning, and AI courses built for finance professionals.
One-time payment - Lifetime access
Or create a free account to start
A step-by-step guide covering Python, SQL, analytics, and finance applications.
Or create a free account to access more
Get full access to all Data Science, Machine Learning, and AI courses built for finance professionals.
One-time payment - Lifetime access
Or create a free account to start
A step-by-step guide covering Python, SQL, analytics, and finance applications.
Or create a free account to access more
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.