• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Excel Settings to Change > Turning AutoComplete On and Off for Text...

Turning AutoComplete On and Off for Text Entries

Like Outlook and other applications, Excel provides an AutoComplete feature that enables it to automatically complete text information when you type the first part of the text. For example, if you have entered Expenses somewhere in a worksheet and click in another cell and type Exp, Excel automatically completes the word for you.

If you prefer to not use AutoComplete, you can turn it off. To do so, you choose Tools, Options to open the Options dialog box, select the Edit tab, and clear the option Enable AutoComplete for Cell Values. Then you click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint