Learn finance, banking, risk, data science and fintech

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.

Try our courses on Data Science for Finance. JOIN FREE

Leave a Reply

Your email address will not be published. Required fields are marked *

Name *

This site uses Akismet to reduce spam. Learn how your comment data is processed.