Excel

Excel Tutorial: Spell Check and Enable Spelling Autocorrect in Excel.

How to Do Spell Check in Excel

Spell check is an important feature in Excel that helps you identify and correct spelling errors in your worksheets. It ensures that your data is accurate and professional-looking. Here’s how you can perform a spell check in Excel:

  1. Open the Excel worksheet that you want to check for spelling errors.
  2. Click on the “Review” tab in the Excel ribbon at the top of the screen.
  3. In the “Proofing” section of the ribbon, click on the “Spelling” button. Alternatively, you can press the “F7” key on your keyboard to start the spell check.
  4. The spell check will begin, and Excel will highlight any misspelled words it finds in the worksheet.
  5. If Excel finds a misspelled word, it will suggest possible corrections in the “Suggestions” box. You can choose the correct spelling from the suggestions or manually type the correct word.
  6. Click on the “Change” button to replace the misspelled word with the correct spelling. If you want to skip a word, click on the “Ignore” button.
  7. Once the spell check is complete, Excel will display a dialog box confirming that the spell check is finished.

By following these steps, you can easily perform a spell check in Excel and correct any spelling errors in your worksheets.

How to Enable Spelling Autocorrect in Excel

Spelling autocorrect is a useful feature in Excel that automatically corrects common spelling errors as you type. It saves you time and helps maintain accuracy in your data. Here’s how you can enable spelling autocorrect in Excel:

  1. Open Excel and click on the “File” tab in the Excel ribbon at the top of the screen.
  2. In the left-hand menu, click on “Options” to open the Excel Options dialog box.
  3. In the Excel Options dialog box, click on the “Proofing” tab.
  4. Under the “AutoCorrect options” section, click on the “AutoCorrect Options” button.
  5. In the AutoCorrect dialog box, make sure the “Replace text as you type” checkbox is selected.
  6. Excel has a built-in list of common misspellings and their correct spellings. You can review and customize this list by scrolling through the “Replace” and “With” columns.
  7. If you want to add your own autocorrect entries, you can type them in the “Replace” and “With” columns and click on the “Add” button.
  8. Click on the “OK” button to save your changes and close the AutoCorrect dialog box.
  9. Click on the “OK” button in the Excel Options dialog box to close it.

Once spelling autocorrect is enabled, Excel will automatically correct common spelling errors as you type. For example, if you accidentally type “teh” instead of “the”, Excel will automatically correct it.

Conclusion

Spell check and spelling autocorrect are valuable tools in Excel that help ensure the accuracy and professionalism of your worksheets. By following the steps outlined above, you can easily perform a spell check and enable spelling autocorrect in Excel. These features will help you catch and correct spelling errors, saving you time and maintaining the integrity of your data.

Leave a Comment