Miscellaneous IssuesBelow are several Frequently Asked Questions and answers on Miscellaneous Issues in Excel. |
Can I check the spelling on my worksheet with one quick command? |
|
| |
|
I deleted an add-in that I was evaluating, and now every time I open Excel I get an
error message that says Cannot find 'C:\MSOFFICE\EXCEL\LIBRARY\MyAddIn.xla'. How do I stop
this from happening?
Keywords: Add-ins, Errors
Posted December 17, 1996
Once the error message comes up, just click the OK button and it Excel will continue to open. Once Excel is open, choose Tools - Add-Ins from the menu. Find the name of the add-in that you deleted and place a check mark in the box beside it. Excel will immediately respond with a message saying that it can't find the add-in and ask you if you want to remove it from the list. Choose yes and it will be removed from the list. This will also stop the error from occurring on startup.
Can I check the spelling on my worksheet with one quick command?
Keywords: Check Spelling Command
Posted January 18, 1996
When you use the Spelling command, Excel compares each word in your range or worksheet with those in its standard dictionary. If Excel does not find the word, it displays the Spelling dialog box.
To check the spelling:
If Excel finds a word that is not in any open dictionary, the Spelling dialog box appears. If the Always Suggest option is turned on, Excel will suggest a new word. Click on the appropriate command button.
If you began checking the worksheet with a cell that was not at the beginning, when Excel reaches the end of the worksheet, it will ask you if you would like to continue the check from the beginning. To avoid this, before activating the Spelling command, make cell A1 active. The Spelling command will then begin its check at the beginning of your worksheet. To do this easily choose Ctrl+Home, or F5 (Goto) and then A1.
Shortcut: Use F7 or click on the Spelling tool on the Standard toolbar to activate the Spelling command.
How can I add names to the dictionary in Excel?
Keywords: Add Names Dictionary
Posted January 18, 1996
You can add to the default custom dictionary words of people and companies you use frequently but Excel would not recognize. To create a custom dictionary, from the menu bar choose Tools - Spelling to display the Spelling dialog box. There needs to be at least one word the Spelling feature does not recognize. Otherwise the Spelling dialog box will not appear.
In the Add Words to edit box, enter the name for the new dictionary. Press Enter. Excel will prompt you as to whether you want to create a new dictionary. Click Yes to create the dictionary. Continue with the spell check or cancel to return to the worksheet.
You can create as many dictionaries as you need. However, you can only use one custom dictionary at a time.
How can I check the spelling of a single word in Excel?
Keywords: Check Spelling Single Word
Posted January 18, 1996
When you use the Spelling command, Excel compares each word indicated with those in its standard dictionary. If Excel does not find the word, it displays the Spelling dialog box.
To check the spelling of a single word in a cell:
If Excel cannot find the word in any open dictionary, it displays the Spelling dialog box. Select the appropriate options from the dialog box. If Excel determines the word is spelled correctly, it displays a message to that effect.
Hint: F7 will also activate the spell checker.
How do I load Add-Ins?
Keywords: Load Add-Ins
Posted January 16, 1996
To load one or more Excel Add-In programs, select Tools - Add-Ins. The Add-Ins Available list shows the installed add-ins, including those that were installed when you installed Excel. Add-Ins with a check mark beside them are currently loaded. To activate an add-in, click on it, or highlight it and press the space bar. The displayed add-ins include those found in the /Excel/Library folder. To add a new add-in to your list, select the Browse button to show the browse dialog box, navigate to where the new add-in is located, choose the add-in (xla), and click OK. When you have activated all the add-ins you need, select OK to return to the worksheet. Excel will then load the add-ins you've selected.
Back to the FAQ Table of Contents
E Pluribus Modem |
Copyright© 1996-1999, Baarns Consulting Group, Inc. - All rights reserved. |