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
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
-
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