Coding Compendium
A free 100-page ebook collecting my projects and tutorials for Raspberry Pi, micro:bit, Scratch and Python. Simply join my newsletter to download it.
By Sean McManus
I received an email from someone asking how to turn off the predictive text in Excel and Word, so I thought I'd write this article to explain how to turn it off. The reader writes: "It is driving me mad and nothing I have tried so far has worked to make it stop." If you're in the same boat, I hope this will help.
NEW: Check out my new book 100 Top Tips: Microsoft Excel!
In Microsoft Excel, the predictive text feature is called Autocomplete. While you're typing content into a cell, Excel will automatically complete what you're typing if it looks like you're repeating something in a similar cell. You can just keep typing to override it, but it's easy to make a slip and end up with something you didn't want in there. To turn off Autocomplete in Excel 2010:
To turn off the predictive text/Autocomplete feature in Excel 2007, follow these steps:
In Microsoft Word, there is a feature that will change your words as you type to correct what Word believes are spelling errors. This type of predictive text is called AutoCorrect. Most of the time, AutoCorrect is a big help, but you can turn it off if you prefer. There's more information on how to use the proofing and spelling tools in Microsoft Word in my book Microsoft Office for the Older and Wiser, but here's a quick guide to turning off AutoCorrect:
To stop Microsoft Word changing what you write in Word 2007, follow these steps to turn off AutoCorrect:
My book Microsoft Office for the Older and Wiser is out now. Through a series of projects, it shows you how to make the most of Word, Excel, PowerPoint and OneNote. You'll learn how to design letters, posters and newsletters; how to work out your holiday budgets and manage your address book with Excel; how to create a photo album with PowerPoint; and how to keep a recipe book using OneNote. There's a bonus chapter showing you how you can use email to keep in touch with friends, too. Find out more about Microsoft Office for the Older and Wiser.
Update: This book is now out of print and the rights have reverted to me. Copies are still available to buy, and you may find you can borrow it from your local library. If you are interested in Microsoft Excel, I recommend my new book, 100 Top Tips: Microsoft Excel.
© Sean McManus. All rights reserved.
Visit www.sean.co.uk for free chapters from Sean's coding books (including Mission Python, Scratch Programming in Easy Steps and Coder Academy) and more!
A free 100-page ebook collecting my projects and tutorials for Raspberry Pi, micro:bit, Scratch and Python. Simply join my newsletter to download it.
Web Design in Easy Steps, now in its 7th Edition, shows you how to make effective websites that work on any device.
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
This book, now fully updated for Scratch 3, will take you from the basics of the Scratch language into the depths of its more advanced features. A great way to start programming.
Code a space adventure game in this Python programming book published by No Starch Press.
Discover how to make 3D games, create mazes, build a drum machine, make a game with cartoon animals and more!