Excel can correct common spelling errors and format email addresses and web links as hyperlinks. In this video, learn how to control and reverse the changes Excel makes automatically.
- [Instructor] When you enter values into an Excel worksheet the program looks at those values to determine if you made any errors it knows how to correct. For example, Excel can correct common spelling errors and also format email addresses and weblinks as hyperlinks. In this movie I will show you how to control, and if you need to, reverse the changes Excel makes automatically. My sample file is the AutoCorrect workbook and you can find it in the chapter 10 folder of your exercise files collection. This is a very simple workbook, I just have a worksheet with two customers and their states.
Let's say that I want to add another customer and they go by the three letter initialism, ACN. So I'll click in cell A4 and I'll type ACN and then press Tab. And you'll notice when I do that Excel changes ACN to CAN and that's because a very common misspelling of the word can, C-A-N, is to transpose the first two letters by typing ACN. However, in this case, I did want ACN so I will need to change that AutoCorrect entry.
To do that I will press Command + Comma to open the Excel preferences dialogue box and then at the top, under Authoring I have AutoCorrect, so I'll click that. In here you'll see that I have a number of sections as well as the ability to add or remove replacement rules. There are five options at the top, the first is to Replace internet and network paths with hyperlinks, I'm going to leave that one selected. Next one is to Capitalize names of days, I always leave that one selected.
The fourth one is Capitalize first letter of sentences, yep, and finally, Replace text as you type. I leave those four options checked so that they operate, however, I usually do stay with the default and leave the Correct TWo INitial CApitals option unchecked, and that's because I work in business, I work with a lot of acronyms and initialisms and I do occasionally need to type names of products or names of companies that have two initial capital letters, so I tend to leave that one unselected, but do what works best for you.
Now let's take a look at the AutoCorrect replacement rules below. You see here at the bottom that we have a list of replacement rules and if I scroll down I can find the acn rule, which is right here. And you see that acn is replaced automatically with can. If I want to delete that rule I can click it to highlight it, like I have here, and click delete. That removes the rule from the list. Now I'll close the preferences dialogue box and then in cell A4 I'll press Delete to get rid of the existing value and now I will type the same term I did before, ACN, all capital letters, press Tab, and you see that Excel did not change it.
And let's say their state is also Oregon, and Return. You can also create new rules, so I'll press Command + Comma to go back to the preferences dialogue and click AutoCorrect and create my new rule. I want to correct Cancellari, the name of the company in cell A3, which is often misspelled with a single L and I want to automatically replace using AutoCorrect spellings with one L with the one with two, which is correct. So in the Replace box I will type the incorrect spelling, C-A-N-C-E-L-A-R-I, then press Tab, and With, the correct spelling, C-A-N-C-E-L-L-A-R-I.
One thing to note is that if you already have a particular rule then when you put in the Replace term the With term will show up automatically. Alright, so my Replacement and With rule look correct so I'll click Add and then I will close the AutoCorrect dialogue box. I'll just make sure that my rule works, C-A-N-C-E-L-A-R-I, press Tab, and I get my AutoCorrect.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.