Join Dennis Taylor for an in-depth discussion in this video Reducing data entry time by expanding AutoCorrect options, part of Excel Tips Weekly.
- Excel has a feature called AutoCorrect.…It pretty much defines itself,…but it also gives us some capability…for being a real time-saver as we work with Excel.…If you're familiar with the Ribbon menu system,…and you're looking for AutoCorrect,…well, good luck, you're not going to be finding it here…unless you go over to the FILE tab,…and even then, we wouldn't be alerted to the idea…that under Options, we've got many, many choices.…Under Proofing,…the choice called AutoCorrect Options.…
It's worth a look.…Changes you make here, or additions you make here…will also happen in your other Office applications.…So, before looking at some of the details here,…let's Cancel and get out of here,…and show you a few options, a few thoughts about…how AutoCorrect works.…First of all, one of its features allows us…to type certain kinds of entries…and automatically insert symbols.…If you type "(c)"…followed by space, punctuation, or Enter,…you automatically get the copyright symbol.…
Similarly, with the letter "r",…you get the registered symbol,…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- 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.