Excel - Auto-Change Dwight to Diapers (Jim Halpert Trick on Dwight Shute) - Episode 1226

3,295 views · Published 19 July 2010 · 2:20 · Indexed 12 November 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial - Use the AutoCorrect options to pull a practical work on a co-worker.

Welcome to the MrExcel podcast, sponsored by MrExcel.com. In this episode, we will be diving into chapter 6 of Excel 2010 in Depth, where we will be discussing a popular trick from the TV show The Office. If you're a fan of the show, you'll know that Jim loves to play practical jokes on his co-worker Dwight. One of his tricks involved setting up a macro so that every time Dwight typed his own name, it would automatically change to "diapers". But did you know that you can easily set this up in Excel without using a macro? Keep watching to find out how.

To set up this prank, we need to go to Excel options. You can access this by clicking on the File menu and then selecting Options from the left-hand navigation. In the Proofing tab, you will find the AutoCorrect options. This is where you can make changes to common misspellings or add your own custom replacements. For example, if someone types "Dwight", we can change it to "diapers" and click "Add". Now, every time someone types "Dwight" in Excel, Word, or PowerPoint, it will automatically change to "diapers". Just remember to click "OK" to save your changes.

This trick is not only limited to names, you can have fun with any word or phrase. For example, you can change your boss's name to something else and have a good laugh around the office. Just make sure to use this prank responsibly and not offend anyone. Thank you for tuning in to this episode of the MrExcel podcast. Don't forget to check out our Excel 2010 in Depth book for more tips and tricks. 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/


Table of Contents:
(00:00) Dwight/Diaplers Trick from TV Show The Office
(00:28) Jim and Dwight's practical jokes
(00:38) Setting up the "Dwight" to "diapers" trick
(00:49) Having fun with co-workers
(01:00) Accessing Excel options
(01:10) Adding a new auto correct options
(01:37) Using the trick in Excel, Word, or PowerPoint
(02:00) Customizing the trick for different names
(02:10) 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 #tutorials 

This video answers these common search terms:
Auto correct options
Diapers
Excel 2010 in Depth
Excel options
Macro in Excel
Misspellings
Office pranks
Practical jokes
The Office television show
Word and PowerPoint

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

More from this channel