Look Who it Was Random video

Excel - Excel Navigation Tip: Double-Click Your Way to Data Mastery - Episode 952

900 views · Published 17 February 2009 · 3:29 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel Navigation Tip: Double-Click Your Way to Data Mastery.

Welcome back to the MrExcel netcast, where we share tips and tricks to help you become an Excel pro. In today's episode, we're going to talk about a handy navigation tip that will save you time and effort when working with large amounts of data. So let's dive in!

Have you ever found yourself scrolling through endless rows and columns of data, trying to get to the end of your spreadsheet? Well, worry no more because we have a solution for you. Our tip for today is all about using your mouse to quickly jump to the end of your data. No more endless scrolling or using the arrow keys to get to the bottom of your dataset.

This tip was shared with me by Laura during one of my seminars in Madison, Wisconsin. And I have to say, it's a game-changer. Instead of using the end key and arrow keys, you can simply double-click on the edge of your current cell to jump to the end of your data. Double-click on the bottom edge to jump to the last row, double-click on the right edge to jump to the last column, and so on. It's a quick and easy way to navigate through your data without having to use the keyboard.

However, there is one thing to keep in mind. If there is a blank cell in your data, the double-click function will stop right before it. This may be a bit frustrating for some users, but don't worry, we have a solution for that too. You can use the control key and arrow keys to achieve the same result. For example, control + down arrow will take you to the last row, even if there are blank cells in between. So whether you're a mouse person or a keyboard person, we've got you covered.

But wait, there's more! As with any tip, there are always different perspectives. Some users, like Greg Turby, were excited to learn this new trick, while others, like Beth Melton and Gary Whiteford, found it to be a bit annoying. They mentioned that they often accidentally double-click on the edge when trying to use the fill handle. So, if you're one of those users, don't worry, you can easily turn off this feature in your Excel settings.

I hope you found this tip helpful and will give it a try in your next Excel project. A big thank you to Laura from Waukesha, Wisconsin for sharing this cool Excel tip with us. And as always, stay tuned for more netcasts from MrExcel, where we'll continue to share valuable tips and tricks to help you excel in Excel. Thanks for watching and see you next time!

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/


Laura from Wisconsin provides today's cool Excel trick: Double click any edge of the active cell and Excel will jump to the edge of the data. Episode 952 shows you how.

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

Table of Contents:
(00:00) Jump to edge of data using Mouse
(00:25) Using the end key to jump to the end of a data range
(00:35) Alternative method using control and arrow keys
(01:34) Laura's trick: double-clicking edges of current cell for navigation
(02:01) Difference between control click and double-click on right edge
(03:02) 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:
Blank cells in data set
Control key in Excel
Double-clicking technique
End key in Lotus 123
Excel tips
Fast data analysis techniques
Keyboard shortcuts
Mouse navigation
Navigation tricks
Pivot table


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

More from this channel