Excel Quickly Navigating In Excel Using The End Keys - Episode 1211.114

2,003 views · Published 17 July 2010 · 1:30 · Indexed 8 November 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Quickly navigating in Excel using the End keys. 

Welcome to another episode of the MrExcel podcast. In this episode, we will be diving into Chapter 14 of our Excel In Depth series, where we will be exploring the powerful End Key Navigation feature.

For those who are not familiar, the End Key is a handy shortcut that allows you to quickly jump to the end of a data set. All you have to do is press the End Key once, and you will see a notification at the bottom of your screen indicating that you are in End mode. From there, you can use the arrow keys to navigate to the end of your data set.

But that's not all - the End Key also allows you to jump over any gaps in your data. For example, if you press End and then the right arrow key, it will skip over any blank columns and take you to the next column with data. This feature is especially useful when working with large data sets, as it saves you time and effort in scrolling through rows and columns.

Some of you may be wondering if the End Key is a relic from the past, as it was originally used in Lotus. However, fear not, as Excel has its own set of shortcuts that achieve the same result. For instance, you can use CTRL and the arrow keys to navigate to the end of your data set or jump over gaps. So, if you have a million rows of data, you can quickly get to the last row by using CTRL+Down.

Thank you for tuning in to this episode of the MrExcel podcast. We hope you found this tutorial on End Key Navigation helpful. Be sure to join us next time for more tips and tricks to help you excel in Excel. Don't forget to like, comment, and subscribe for more netcasts by MrExcel. See you soon!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Navigating with the End Key
(00:10) Using the End Key 
(00:20) End Mode and Arrow Keys 
(00:30) End and Down or End and Right 
(00:40) Jumping the Gap with End and Arrow Keys 
(00:50) Alternative Shortcut Keys 
(01:05) Fast Navigation for Large Data Sets 
(01:15) Clicking Like really helps the algorithm

This video answers these common search terms:
Arrow keys navigation
Chapter 1'End Key Navigation
Contiguous block with data
CTRL and arrow keys shortcut
End mode
Fast ways for large datasets
Gap jumping
Getting to the last row
Jumping to the end of a data set
MrExcel podcast
Using the End key

For anyone looking for the Frequency Distribution Video, it is at http://youtu.be/jbaXnT5CX18

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1152893/

More from this channel