Icons on the worksheet in Excel

Applies to
Microsoft Excel 2002

Microsoft Excel 2002 introduces new worksheet icons to assist you with your work. The following table will help you identify the new icons and their functions in the product.

Worksheet Icon Description
Error indicator in cell

A green triangle in the upper-left corner of a cell indicates an error in the formula in the cell. If you select the cell, the Error Checking Options button appears. Click the arrow next to the button for a list of options.

 Note   The color of the error checking triangle indicator can be changed by clicking Options on the Tools menu, and then clicking the Error Checking tab.

 Smart tag indicator in cell A purple triangle in the lower-right corner of a cell indicates a smart tag. If you rest the mouse cursor over the cell, the Smart Tag Actions button appears. Click the arrow next to the button for a list of smart tag actions.
Button image

The AutoCorrect Options button first appears as a small, blue box when you rest the mouse pointer near a hyperlink on a worksheet, and changes to a button icon when you point to it. Click the arrow next to the button for a list of AutoCorrect options.

 Note   When the small, blue box is visible, you can also press ALT+SHIFT+F10 to display the smart tag button menu.

The Paste Options button appears near your pasted selection after you paste text or data within a worksheet. When you click the button, a list appears that lets you determine how the information is pasted into your worksheet.

The available options depend on the type of content you are pasting, the program you are pasting from, and the format of the text where you are pasting.

The Auto Fill Options button appears near your filled selection after you fill text or data in a worksheet. When you click the button, a list appears to give you options for how to fill the text or data.
Button image The Insert Options button appears next to your inserted cells, rows, or columns when the formatting is different between the original and the inserted cells, rows, or columns. When you click the arrow next to Insert Options, a list of formatting options appears.