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

How can I enforce the feature?

thanks.

Sat, 07 Jul 2007 18:52:59 +0900 from kang :
sometimes excel gives me the cell data I input already.
sometimes it doesn't.

How can I enforce the feature?

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Autocomplete works only on the active column in contiguous ranges.


Gord Dibben MS Excel MVP

On Sat, 07 Jul 2007 18:52:59 +0900, kang wrote:

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

How can I enforce the feature?

thanks.

Thanks.
Is it possible to make some cells as if it is in contigous ranges?

Gord Dibben wrote:
Autocomplete works only on the active column in contiguous ranges.


Gord Dibben MS Excel MVP

On Sat, 07 Jul 2007 18:52:59 +0900, kang wrote:

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

How can I enforce the feature?

thanks.

Not that I know of.

Gord

On Mon, 09 Jul 2007 11:59:29 +0900, kang wrote:

Thanks.
Is it possible to make some cells as if it is in contigous ranges?

Gord Dibben wrote:
Autocomplete works only on the active column in contiguous ranges.


Gord Dibben MS Excel MVP

On Sat, 07 Jul 2007 18:52:59 +0900, kang wrote:

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

How can I enforce the feature?

thanks.