I have created a child's spelling game that uses the "if" function to tell
the user if the word spelt is correct or not. The correct spelling is in a
hidden cell above the cell where the word is to be entered. When you commence
typing in the word, eg "b" for "ball", excel prompts the word ball as it
recognises it from the cell in the spreadsheet. I want to know if and how I
can turn off this prompting

Tools/ Options/ Edit:
uncheck "Enable AutoComplete for cell values"
--
David Biddulph

"Kruja's owner" <Kruja's wrote in message
...
I have created a child's spelling game that uses the "if" function to tell
the user if the word spelt is correct or not. The correct spelling is in a
hidden cell above the cell where the word is to be entered. When you
commence
typing in the word, eg "b" for "ball", excel prompts the word ball as it
recognises it from the cell in the spreadsheet. I want to know if and how
I
can turn off this prompting

Thanks, David. It's easy when you know how. I'm used to working with numbers
and formulas - focus has changed - child education, now that a 6 year old
who needs extra curricular encouragement has entered the equation

"David Biddulph" wrote:

Tools/ Options/ Edit:
uncheck "Enable AutoComplete for cell values"
--
David Biddulph

"Kruja's owner" <Kruja's wrote in message
...
I have created a child's spelling game that uses the "if" function to tell
the user if the word spelt is correct or not. The correct spelling is in a
hidden cell above the cell where the word is to be entered. When you
commence
typing in the word, eg "b" for "ball", excel prompts the word ball as it
recognises it from the cell in the spreadsheet. I want to know if and how
I
can turn off this prompting

"spelt" is a type of wheat.

How will you know if the children have spelled a word correctly?


Gord Dibben MS Excel MVP

On Thu, 22 Feb 2007 05:53:15 -0800, Kruja''s owner
wrote:

Thanks, David. It's easy when you know how. I'm used to working with numbers
and formulas - focus has changed - child education, now that a 6 year old
who needs extra curricular encouragement has entered the equation

"David Biddulph" wrote:

Tools/ Options/ Edit:
uncheck "Enable AutoComplete for cell values"
--
David Biddulph

"Kruja's owner" <Kruja's wrote in message
...
I have created a child's spelling game that uses the "if" function to tell
the user if the word spelt is correct or not. The correct spelling is in a
hidden cell above the cell where the word is to be entered. When you
commence
typing in the word, eg "b" for "ball", excel prompts the word ball as it
recognises it from the cell in the spreadsheet. I want to know if and how
I
can turn off this prompting

That may depend which side of the Atlantic, Gord. Either spelt or spelled
is accepted over here.
But we've got enough confusion in Excel usage over different date formats,
without getting into an argument over spelling. :-)
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
"spelt" is a type of wheat.

How will you know if the children have spelled a word correctly?

Gord Dibben MS Excel MVP

On Thu, 22 Feb 2007 05:53:15 -0800, Kruja''s owner
wrote:

Thanks, David. It's easy when you know how. I'm used to working with
numbers
and formulas - focus has changed - child education, now that a 6 year old
who needs extra curricular encouragement has entered the equation

"David Biddulph" wrote:

Tools/ Options/ Edit:
uncheck "Enable AutoComplete for cell values"

"Kruja's owner" <Kruja's wrote in
message
...
I have created a child's spelling game that uses the "if" function to
tell
the user if the word spelt is correct or not. The correct spelling is
in a
hidden cell above the cell where the word is to be entered. When you
commence
typing in the word, eg "b" for "ball", excel prompts the word ball as
it
recognises it from the cell in the spreadsheet. I want to know if and
how
I
can turn off this prompting

Thanks for update David.

I look at everything from a narrow "Canuckese" view.


Gord

On Thu, 22 Feb 2007 17:53:43 -0000, "David Biddulph"
wrote:

That may depend which side of the Atlantic, Gord. Either spelt or spelled
is accepted over here.
But we've got enough confusion in Excel usage over different date formats,
without getting into an argument over spelling. :-)