Microsoft Word automatically highlights grammar or spelling errors. Surprisingly, Microsoft Excel does not. This may be partly due to the fact that Excel as a spreadsheet application is mainly focused on numbers. As a result, most Excel users may not be aware of the application’s spell-checking features. However, this doesn’t change the fact that doing a spell check on your Excel is essential to ensuring quality work.
In a standard Microsoft Excel workbook, you have a worksheet with many different cells and formulas. To perform spell check on an entire workbook, a worksheet, a specific cell, or formulas requires specific methods. Below, we explain how to perform spell check in Microsoft Excel using these methods.
How to perform a spell check of an Excel workbook
In Microsoft Excel, a worksheet is a single workbook. To conduct spell check on a worksheet, make sure you are actively checking it. Here’s how to do so:
Step 1: Click the Start button on the Taskbar and type outstanding to search for apps.
Step 2: From the results, click on the Microsoft Excel application and then navigate to the Excel document to open.
Step 3: At the bottom of the Excel application, click the tab of the name of the sheet for which you want to perform a spell check.
Step 4: On the Excel Ribbon, click the Review tab.
Step 5: In the Proofing group, click the Spelling button and this will launch the Spelling dialog window. Alternatively, you can press the F7 key on your keyboard, and this will also launch the Spelling dialog window.
Step 6: After the Spelling dialog window appears, you will see the spelling errors in the document if any and suggest the correct spelling. For highlighted errors, you can choose one of the following options:
- Skip once: if there are multiple typos, selecting this option means that you only want to ignore one error.
- Ignore all: if there are multiple occurrences of typos, selecting this option means you want to ignore all errors.
- Add to dictionary: if Excel incorrectly marks a word as an error, it may be because the word is not in the language dictionary. You can choose to add the word to your dictionary.
- Change: if multiple typos occur, selecting this option means that you only want to change a single error instance.
- Change all: if multiple typos occur, selecting this option means that you want to change all cases.
- AutoCorrect: if you want Excel to automatically correct a typo.
After you go through all the errors in the worksheet, the spell check dialog window will close and you will receive the following message:
How to perform spell check for multiple sheets
If you have a lot of worksheets in your Excel file and you have specific ones that you want to run a spell check on, here’s what you should do:
Step 1: Open an Excel document on your computer. At the bottom of the Excel app, where the sheet’s name tab is, click the Ctrl key on your keyboard while clicking the tabs for which you want to perform a spell check.
Step 2: After selecting the tabs, press the F7 key on your keyboard to launch the Spelling dialog window. Excel will run a spell check on the selected worksheets.
How to do a spell check for an Excel workbook
Multiple worksheets in an Excel file turn it into a workbook. To perform a spell check for an entire workbook, you need to do the following:
Step 1: Open an Excel document on your computer. At the bottom of the Excel application where the sheet’s name tab is, right-click any tab and click Select All Sheets.
Step 2: With all the sheets selected, press the F7 key on your keyboard to launch the Spelling dialog window. Excel will run a spell check on all worksheets.
How to do a spell check for text in a formula
Usually features text in formulas in Excel worksheets. To perform a spell check of text used in a formula, the user must manually highlight the text in the formula. Here’s how to do so:
Step 1: Click on the cell with the formula you want to run the spell check on. The formula in the cell will be displayed in the formula bar.
Step 2: In the formula bar, highlight the text in the formula.
Step 3: Press the F7 key on your keyboard to launch the Spelling dialog window. Excel will run a spell check on the selected text.
Using this method means you’ll have to test each formula individually, which doesn’t work. However, Excel does not provide an easier approach to testing text in formulas.
Breaking external link references in Microsoft Excel
You can refer to external worksheets or documents when working with formulas in Microsoft Excel. However, these external references may no longer work when Excel files are moved or shared. This may result in your Excel file displaying error messages. Removing these broken links is quite easy using the find and replace feature in Excel.
Categories: How to
Source: thpttranhungdao.edu.vn/en/
