Click From List (again)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Bunton - 27 Jan 2007 18:38 GMT

This si a repeat becauise I could not find the original or a response on the
group.

A cell on a spread sheet has (mysteriously) acquired a reaction which as
far as I can see is "Click From List"
e.g when I enter a it provides the entry Annual>
o Owner

I can find no way to turn this off .
[or modify the list if I wanted to
nor can I find a way to turn it on if I wanted it!]

Signature

Jim Bunton

Reply to this Message

Gord Dibben - 27 Jan 2007 20:05 GMT

Tools>Autocorrect options probably holds the key to a solution.

Gord Dibben MS Excel MVP

>This si a repeat becauise I could not find the original or a response on the
>group.
[quoted text clipped - 7 lines]
>[or modify the list if I wanted to
>nor can I find a way to turn it on if I wanted it!]

Reply to this Message

Jim Bunton - 27 Jan 2007 20:10 GMT

Thanks for the response Gordon -
I've had a go at autocorrect - if the answer's there I can't see it I'm
afraid

> Tools>Autocorrect options probably holds the key to a solution.
>
[quoted text clipped - 12 lines]
>>[or modify the list if I wanted to
>>nor can I find a way to turn it on if I wanted it!]

Reply to this Message

Gord Dibben - 27 Jan 2007 20:36 GMT

Jim

Look for the letter "o" under "Replace"

If found, what is the "With"

If no joy...........you mention "a cell".

Is it just the one cell that displays this behaviour?

Are you just typing the letter "o" or "=o" which could mean that "o" is a name
referring to ="Owner"

Gord

>Thanks for the response Gordon -
>I've had a go at autocorrect - if the answer's there I can't see it I'm
[quoted text clipped - 16 lines]
>>>[or modify the list if I wanted to
>>>nor can I find a way to turn it on if I wanted it!]

Reply to this Message

Jim Bunton - 28 Jan 2007 15:01 GMT

Hi again Gordon - GOT IT!
What is actually happening is:
In any cell - if you enter a character the sheet looks at all text entries in that specific column.
If one exists with the initial character the same as the one typed then the sheet provides an "AutoComplete"
Thus, if you enter the text 'Rubbish' in a column then in an empty cell in that column you type R it expands to Rubbish
It is specific to columns (not rows)
So - you were right - it's on the Tools menu - Switch Off "AutoComplete"
It doesn't seem possible to switch this on or off for specific cells.

If you right click a cell then select 'Pick From List' is displays a list of the text entries in the specifc column [if a word appears more than once in the column it only appears once in the 'Pick From List'

I cannot see any facility to stop this specific AutoComplete.
[Well maybe you could create a custom list for the specific cell making the custom list empty - what a rigmarole!]
[Menu item Data > validation MAY also be relevant - but setting it to 'any value' doesn't stop this autocomplete]

Well - thanks for your responses to my posting.

> Jim
>
[quoted text clipped - 31 lines]
>>>>[or modify the list if I wanted to
>>>>nor can I find a way to turn it on if I wanted it!]

Reply to this Message

Gord Dibben - 28 Jan 2007 18:16 GMT

Thanks for the feedback Jim

Got thrown off course by your reference to "a cell on a spreadsheet"

Assumed it was only "one cell"

Gord

>Hi again Gordon - GOT IT!
>What is actually happening is:
[quoted text clipped - 48 lines]
>>>>>[or modify the list if I wanted to
>>>>>nor can I find a way to turn it on if I wanted it!]

Reply to this Message