 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2006how to edit auto complete
I would like to edit the contents of the auto complete function because I no longer need some of the things that it tries to use. How do I do this? Thanks. Are you talking about AutoCorrect? Auto complete and auto correct are two different things. Auto complete is either on or off. I think you mean AutoCorrect. Go to the Tools menu, choose AutoCorrect Options and delete the items in the dialog that appears.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com >I would like to edit the contents of the auto complete function >because I no > longer need some of the things that it tries to use. How do I > do this? > Thanks. Are you talking about AutoComplete which uses contiguous data in the same column as the basis for completion? As long as you have data in that column, AutoComplete will function. Disable it at Tools>Options>Edit OR are you talking about AutoCorrect which can be found under Tools>AutoCorrect and is easily editable. Gord Dibben MS Excel MVP >I would like to edit the contents of the auto complete function because I no >longer need some of the things that it tries to use. How do I do this? >Thanks. I was talking about auto complete (how it completes what you are typing and you can use wat it gives you or finish typing what you want.) So from what I gather from the above posts. there is no way of editing what it wants to use for auto complete except for editing the cells above in the same column. Is that right? Am I being clear? Yes, that is correct,. sometimes I place text above in hidden rows that I know will be handy for auto complete there is no way to edit the function itself unlike autocorrect SignatureRegards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey >I was talking about auto complete (how it completes what you are typing and > you can use wat it gives you or finish typing what you want.) [quoted text clipped - 3 lines] > the > same column. Is that right? Am I being clear? But you can use CTRL+Z (Undo) when AutoComplete does something you do not want. SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email >I was talking about auto complete (how it completes what you are typing and > you can use wat it gives you or finish typing what you want.) [quoted text clipped - 3 lines] > the > same column. Is that right? Am I being clear? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.