Review and Correct Errors : Formula Review Watch « Formula « Microsoft Office Excel 2007 Tutorial

1.	Introduction
2.	Editing
3.	Format Style
4.	Table
5.	Chart
6.	Formula
7.	Workbook Worksheet
8.	Wordart Clip Art Shape Picture
9.	PivotTable PivotChart
10.	Data Analysis
11.	Macro ActiveX Add in
12.	Security
13.	Collaboration
14.	Database functions
15.	Date Time functions
16.	Engineering functions
17.	Information functions
18.	Logical functions
19.	Lookup Reference functions
20.	Math Trigonometry functions
21.	Statistical functions
22.	Text functions

6.9.1.Review and Correct Errors

Select a cell that contains a green triangle in the upper left corner.

Click the Error Smart Tag button. Click one of the troubleshooting options:

To have Excel fix the error, click one of the available options specific to the error.

To find out more about an error, click Help on this Error.

To remove the error alert, click Ignore Error.

To fix the error manually, click Edit in Formula Bar.

6.9.Formula Review Watch
	6.9.1.	Review and Correct Errors
	6.9.2.	Watch Cells and Formulas
	6.9.3.	Remove Cells from the Watch Window
	6.9.4.	Set Error Checking Options
	6.9.5.	Correct Errors

All other trademarks are property of their respective owners.