Excel - Unlocking Forgotten Word Lock Combinations: How Many Possible Combinations? - Episode 1110

3,103 views · Published 28 September 2009 · 2:44 · Indexed 24 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Unlocking Forgotten Word Lock Combinations: How Many Possible Combinations?

Welcome back to the MrExcel netcast, where we help you become an Excel pro. In today's video, we're taking a break from promoting my books and instead, we're promoting the Merriam-Webster Dictionary. Why, you may ask? Well, because we're tackling a problem that many of us have faced - forgetting the combination to a word lock. 

I received an email from Erik, who is in desperate need of help. He has a word lock with 5 rings, each with 10 different letters, and he has forgotten the combination. So, how many possible combinations are there? Well, we can solve this by taking 10 and multiplying it by itself 5 times, or simply raising it to the 5th power. That gives us a whopping 100,000 possible combinations. 

Now, if you're thinking of trying all 100,000 combinations, let me save you some time. Assuming you can spin the lock at a rate of 2 combinations per second, it would still take you 55 hours to try them all. And let's not forget, you'll also have to spend six bucks on a dictionary to figure out which words to use. So, what's the solution? 

Well, I suggest trying the default combination - "space". Most word locks come with this as the default combination and many people forget to change it. So, it's worth a shot before you spend 55 hours trying every possible word. And if that doesn't work, it may be easier to just buy a new lock. 

I hope this video helped you solve your word lock dilemma. Don't forget to hit the like button and subscribe to our channel for more Excel tips and tricks. And if you have any other Excel questions, feel free to send them in and we may feature them in our next netcast. Thanks for watching and I'll see you next time on the MrExcel netcast.

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) Word Lock Combinations
(00:31) Details of the problem
(00:48) Calculation of possible combinations
(01:03) Formatting the answer
(01:14) Formatting cells
(01:24) Final answer and suggestion
(01:42) List of possible combinations
(01:54) Suggestion for a specific combination to try
(02:04) Alternative solution
(02:14) Additional cost for solution
(02: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:
Buying a new lock
Combination lock
Fast way to calculate combinations
Forgotten combination
ings on lock
Merriam-Webster Dictionary
Number of combinations
PivotTable, Data Crunching book
Possible words with 5 rings on lock
Solving combination lock problem
Trying the word space as a combination

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



Erik has a combination lock and has forgotten the combination. He wonders how many possible combinations there are for the lock. Episode 1110 suggests some solutions.

This blog is the video 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

More from this channel