how to enforce autocomplete data

  • Thread starter Thread starter kang
  • Start date Start date
K

kang

sometimes excel gives me the cell data I input already.
sometimes it doesn't.

How can I enforce the feature?

thanks.
 
Sat said:
sometimes excel gives me the cell data I input already.
sometimes it doesn't.

How can I enforce the feature?
Click to expand...

Autocomplete doesn't kick in till you've entered enough to be unique.

So if you have
zxsfgfdsgdfsgdfs,gdsf,ng,sf.g,sfdgsdg,sdhg,s.h,gsh,ngbh1
and
zxsfgfdsgdfsgdfs,gdsf,ng,sf.g,sfdgsdg,sdhg,s.h,gsh,ngbh2
in previous cells, autocomplete won't do you much good since those
are unique only in the last character.
 
Autocomplete works only on the active column in contiguous ranges.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enforce format 2
Secure Erase Samsung Galaxy S7 8
Excel Concatenate Form Name to Parse for function 1
AutoComplete in EXCEL 1
Two types of Data Validation in a cell? 8
US Justice Department renews push to mandate phone backdoor 0
Data type enforcement in DataGridView 6
Excel Autocomplete entry - Delete - How? 7

Back
Top