- Types of Data You Enter into Excel
- Entering Different Types of Data into a Cell
- Controlling the Next Cell Selection
- Using Copy, Cut, Paste, Paste Special to Enter Data
- Using Text to Columns to Separate Data in a Single Column
- Inserting Symbols and Equations into a Cell
- Using Web Queries to Get Data onto a Sheet
- Using Series to Quickly Fill a Range
- Editing Data
- Working with Tables
- Fixing Numbers Stored as Text
- Spellchecking Your Sheet
- Finding Data on Your Sheet
- Using Data Validation to Limit Data Entry in a Cell
Spellchecking Your Sheet
Just like Word, Excel has a spellchecker included. To access it, go to Review, Proofing, Spelling. It reviews all text entries on the sheet. You can configure the options, such as Ignore Words in Uppercase, by clicking the Options button in the Spelling dialog box, or by going to File, Options, Proofing.
If you click the AutoCorrect Options button in the Excel Options dialog box, the AutoCorrect dialog box opens, allowing you to configure how you want the AutoCorrect to work, including automatically replacing text as you type. For example, if you like to abbreviate department as dept. but need it spelled out, you can configure that from this dialog box. Type dept. in the Replace field and department in the With field and click Add. Next time you type dept. in Excel, after you press the spacebar, it will be corrected to department.