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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920