Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

NOTE You can change various options for spell check by clicking the Options button in the Spelling dialog box to display the Proofing section in the Excel Options dialog box. These options apply to all your Microsoft Office programs. You can also display the Custom Dictionaries dialog box by clicking the Custom Dictionaries button. You can use the Custom Dictionaries dialog box to edit the word list in a custom dictionary or to create a new custom dictionary. You can add existing custom dictionaries, such as a technical dictionary or a list of product names, to the list of dictionaries used by Office programs and specify the language for which each dictionary is used. You can also remove a custom dictionary. Unless multiple sheets are selected, the Change , Change All , Ignore Once , and Ignore All buttons only affect the current worksheet.



P ROCEDURES

1. Select the Spelling button in the Proofing group on the Review tab. 2. To change the spelling of an identified error, select the desired spelling from the Suggestions list box or edit it yourself in the Not in Dictionary box. 3. Select Change or Change All , as desired. 4. To ignore an identified error, select Ignore Once or Ignore All , as desired. 5. To add an identified word to the custom dictionary, select . 6. When prompted, select to end a completed spell check.  S TEP - BY -S TEP

From the Student Data directory, open SALES2.XLSX . Run the spelling checker to check a workbook for errors.

If necessary, select cell A1 .

Page 70

OFFICEPRO, Inc.