Look Who it Was Random video

Excel - Shortcut When Using Filter Drop-Downs in Excel - Jump to Letter - Episode 638

313 views · Published 26 March 2009 · 1:34 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: a Quick Way to Jump through a long list of items in the Excel Filter drop-down.

Welcome back to another MrExcel netcast! In today's episode, we have a great tip sent in by one of our frequent contributors, Joe Martin. We were discussing auto filter a few weeks ago, and Joe mentioned a cool trick that we didn't cover. Have you ever struggled with navigating through a long list of unique values in auto filter? Well, Joe has a solution for that.

Instead of using the slider to scroll through the list, Joe suggests typing the first letter of the value you're looking for. For example, if you're trying to find the "Ls", simply type "L" and the list will instantly jump to that section. From there, you can easily scroll through the "Ls" and find the value you need. This trick also works with other letters, making it a quick and efficient way to navigate through long lists.

But that's not all! Joe also shared a few other navigation shortcuts for auto filter. While the list is open, you can use the page up and page down keys to move through the list, or the home and end keys to go to the beginning or end of the list. These shortcuts can save you time and frustration when working with large data sets.

I hope you found this tip helpful and thank you to Joe for sharing it with us. And as always, thank you for tuning in to the MrExcel netcast. Don't forget to hit that subscribe button and leave a comment below with any other tips or tricks you'd like to see us cover. We'll see you next time for another netcast from MrExcel!"

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/


Joe Marten sends in todays tip; how to quickly navigate through the AutoFilter list when there are far too many entries in the list. Episode 638 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Table of Contents:
(00:00) Introduction 
(00:12) Tip from Joe Martin 
(00:22) Using the slider in Auto filter 
(00:32) Joe's tip: typing the first letter 
(00:43) Example: finding "Ls" 
(00:53) Additional navigation tricks 
(01:03) Favorite tip: hitting the first letter 
(01:13) Thanks to Joe and conclusion 
(01:24) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Auto filter
Column with hundreds of values
Home key/End key
List sorting
MrExcel netcast from Joe Martin
Navigation tricks
Page up/Page down
Slider
Typing first letter
Unique values


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

More from this channel