The slow way to the end of Excel

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Some people have way too much time on their hands …. and this was pre-lockdown!

Hunter Hobbs decided to find out how long it takes to scroll down to the very bottom row of Excel.  That’s row 1,048,576.  It only takes a moment and two keystrokes to get there, but Hunter decided to take ‘the road less travelled’.

It took him 9 hours 36 minutes and 10 seconds but you can see a time-lapse version that’s only 2 min 39 seconds.

I hope someone will take Mr Hobbs aside to show him how to do the same thing and more in a few seconds:

Get to the bottom row:  Ctrl + down arrow

Get to the end column:  Ctrl + right arrow

We got to the very end of Excel in a few seconds, including the time to take this screen shot.

the slow way to the end of excel 11988 - The slow way to the end of Excel

Excel – a history of rows and columns
Hiding Columns and Rows in Excel
8 tips for great Excel Sparklines
Make an Excel PivotTable with multiple or nested rows

Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address