Solved how do I check the word bank in excel

June 13, 2013 at 15:07:25
Specs: Windows 7
I did a spell check in excel but it did not pick up 'f' as an incorrect word (should have been 'of'). On investigation it also accepted 't' and 'g'. How can I remove 'f' etc from the main dictionary so that it shows up as an incorrect word.

See More: how do I check the word bank in excel

Report •

✔ Best Answer
June 14, 2013 at 23:58:50
I have now found a solution. The dictionary to alter is the exclude dictionary. I found this information on the following site:
http://wordfaqs.mvps.org/ExcludeWor...

It works.



#1
June 13, 2013 at 17:10:19
Having a single letter is not necessarily a spelling error or incorrect word.

See here:

http://support.microsoft.com/kb/198042

MIKE

http://www.skeptic.com/


Report •

#2
June 13, 2013 at 17:11:43
As far as I know, the only single letter that Excel will pick up as misspelled is "i". It will assume you meant "I" as in "I went to the store." As long as it is bringing up the dictionary, it will also offer you some other choices.

If the spell checker assumed that every "single letter" was misspelled, it would flag sentences like this with multiple misspellings:

I got a D in Math class but a B in Science, so I guess my average is C.

There are also times when a letter might be used as a unit of measure, such as m for meter and x for an unknown value. In addition, a lettered bullet list would be flagged as a whole bunch of misspelled words.

In your case, "f" could be a misspelling of "of", "if" or "fa" so you wouldn't want to hardcode anything into the AutoCorrect list.

However, there is a workaround if you really need to flag single letters as misspellings.

1 - In Excel (assuming 2007 or later) Click File...Options...Proofing...AutoCorrect Options
2 - In the Replace box enter f
3 - In the With box enter ff
4 - Repeat this process for any other single letter you want to flag as a misspelling

Whenever you accidentally type one of the single letters that you set up in AutoCorrect it will be replaced with the e.g. ff, rr, dd, etc. Since ff, rr, dd, etc. are not in the Office dictionary, they will be flagged as misspelled words when you spell check the document.

Just keep in mind the the AutoCorrect options are universal to Office, not just Excel. If f will show up as ff in Excel, it's also going to show up as ff in Powerpoint, Word, etc.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
June 13, 2013 at 17:17:36
Hey Mike,

I checked the MS site you provided the link to. They say:

"...Word does not flag "R" as a misspelling or grammatical error. There is no good workaround for this type of problem. "

As you can see from my response above, there is indeed a "good workaround" as long one considers a final spell check as an integral part of the "workaround".

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
June 13, 2013 at 17:32:14
My mistake, the link is for MS Word,
the OP was asking about Excel.

MIKE

http://www.skeptic.com/


Report •

#5
June 13, 2013 at 18:45:36
No, you were right, the single letter issue is the same for Word and Excel.

My point was that MS says there is no good workaround when indeed there is. One would think that MS would have suggested the fairly simple workaround that I did. They're the experts, aren't they?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
June 14, 2013 at 04:05:00
there is no good workaround

What's good for the Goose, may not be good for the Gander.

Personally, the default behavior is fine with me.

MIKE

http://www.skeptic.com/


Report •

#7
June 14, 2013 at 04:14:20
DerbyDad03

Was just playing around with the spell checking, and found that your workaround,
of replacing f with ff, only works within a cell.

If you use a Text Box the workaround is ignored.

EDIT ADDED:

The workaround DOES work in a Comment Box.
Which make sense.

MIKE

http://www.skeptic.com/


Report •

#8
June 14, 2013 at 09:27:15
Try any built-in "AutoCorrectable" misspelling in a Text Box and you'll probably find that it won't work.

e.g. recieved gets AutoCorrected in a cell and comment, but not in a Text Box.

I submit that it's not fair to say that my workaround doesn't work in a Text Box when in fact it's the AutoCorrect feature that is not even available. ;-)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#9
June 14, 2013 at 23:35:05
Thank you all for the time you have taken to reply. However my question was asking for information on accessing the main dictionary.
I have accessed the custom dictionary and in that I have found words that I have added over time. If I can access the custom dictionary then I assume that the main dictionary may also be accessible.

Report •

#10
June 14, 2013 at 23:58:50
✔ Best Answer
I have now found a solution. The dictionary to alter is the exclude dictionary. I found this information on the following site:
http://wordfaqs.mvps.org/ExcludeWor...

It works.


Report •

#11
June 15, 2013 at 06:14:54
Thanks for the update, a very interesting site.
Glad you got your problem solved.

One note on the link,
as given it would not take me to the indicated page,
I ended up on a blank page.

I have to go to the main site at: http://wordfaqs.mvps.org/

Then navigate to the Tutorial Section
then scroll down to the Spelling and Grammar section
then click the link to the: How to “remove” a word from Word's main spelling dictionary by creating an exclusion dictionary

Was unaware of an Exclusion Dictionary,
so I learned something new.

Again, thanks for the update.

MIKE

http://www.skeptic.com/


Report •

#12
June 15, 2013 at 10:33:10
daycartes,

I have a question. Please don't consider this as pushback of any kind. I'm simply curious about the use of the Exclusion dictionary to solve your issue.

What is different (better?) about creating an Exclusion dictionary and adding single letters vs. adding an AutoCorrect entry to "create" misspelled words from your single letters?

I haven't tried the steps at the MVP site, but it does seem like a lot more work than just adding an AutoCorrect entry through the Proofing options.

Do you gain any functionality with the Exclusion dictionary vs. the AutoCorrect method for your specific single letter issue?

Thanks for any insight you can share.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#13
June 15, 2013 at 14:04:09
Thanks for your question DerbyDad03.The way I see it is that the exclude dictionary was designed purely to solve my problem. I realise that you were able to 'think outside the box' and come up with a workaround, but Microsoft have already thought about it and hard wired the solution into their programme. I was able to find the solution read through the article, try out the solution to see if it worked and respond with my own reply all within 22 minutes.
I hope that that answers your question.

Thanks again for your time and trouble.

daycartes


Report •

Ask Question