how to edit auto complete

[Guest]

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.

 

[Chip Pearson]

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Gord Dibben]

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

 

[Guest]

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?

 

[Peo Sjoblom]

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

--

Regards,

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

 

[Bernard Liengme]

But you can use CTRL+Z (Undo) when AutoComplete does something you do not
want.