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