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.

Learn the skills required to excel in data science and data analytics covering R, Python, machine learning, and AI.

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Saylient AI Logo

Take the Next Step in Your Data Career

Join our membership for lifetime unlimited access to all our data analytics and data science learning content and resources.