Tame your computer - a textual turn off


In her weekly series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to turn off automatic completion of cell entries (Microsoft Excel*) ...

If you are not a "hunt-and-peck" typist and look at your screen rather than your keyboard when you type, you might have noticed that Microsoft Excel completes text entries you type in a column if the first few characters match something in that column. You can either accept the "AutoComplete" text by pressing the ENTER key - or if you want to enter something else, you simply continue typing.

But you can also turn off automatic completion once and for all.

Here's how:

1. Choose the Tools, Options command.
2. On the Edit tab, clear the Enable AutoComplete for cell values check box.

And if this AutoComplete feature in Word drives you potty ... have a look at my tip # 157.

Finally, we still have some places left on our next half day Excel Further Use course, scheduled for the afternoon of 17 September. The session will be held at the Sun House in Cambridge and will be 97 pounds (+VAT) only. See http://www.roem.co.uk/msexcfu.html for further details.

* Unless stated otherwise, these tips were written for Microsoft Office 2003.
Most of what is covered however will also apply to earlier versions.

28 August 2007

Karen Roem offers software training and support through her company Roem Ltd.
Contact her by email (
Karen@roem.co.uk) or visit her website at http://www.roem.co.uk


Karen Roem
Microsoft Office-ionado

Roem Ltd – software training and support