- Editing Data
- Overwriting and Deleting Data
- Undoing and Redoing Changes
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Cutting, Copying, and Pasting Data
- Flipping Rows and Columns
- Moving Data
- Finding Data
- Replacing Data
- Adding and Viewing Cell Comments
- Editing and Deleting Cell Comments
- Inserting Symbols
- Tracking Changes
- Accepting or Rejecting Tracked Changes
- Checking Spelling
If your worksheet is for your eyes only, you might not think that misspellings are a big deal. But if you plan to turn over your worksheet to your manager, she might not think the mistakes are so minor. Fortunately, you can use Excel to check your spelling quickly and easily.
Click the Spelling button on the Standard toolbar. The Spelling dialog box opens, displaying the first spelling error it finds.
If the correct spelling of the word appears in the Suggestions list, click the word. If the correct spelling isn’t listed, type the correction directly in the Not in Dictionary box.
Click Change to change only this instance of the word, or Change All to correct all instances in the workbook. Excel makes the change, and flags the next word.
If the word flagged by Excel is not misspelled (for example, it’s a proper name), click Ignore Once to ignore this instance or Ignore All to ignore it throughout.
If you started the spelling check in the middle of the workbook, Excel checks until it reaches the end. If you want to continue checking from the beginning, click Yes.
As Excel continues locating spelling errors, change or ignore them as needed. Excel notifies you when all inaccuracies have been reviewed; click OK.