Strategy: We’ve become used to red indicators for cell comments and green indicators for Excel errors. Why is Excel marking all of these seemingly innocent values?
Well, those are smart tags. If you enter a stock market ticker symbol in a cell, Excel adds a smart tag indicator, as shown in Fig. 1277.
The smart tag lets you insert the stock price for the symbol, as shown in Fig. 1278.
This is fine, but even cells that just look like ticker symbols are marked. The Truetime company went public in 1999 with the ticker symbol TRUE. Symmetricon bought them out in 2002. The TRUE ticker is no longer valid, yet everyone using Excel 2002 or 2003 has to put up with the annoying SmartTags on their logical formulas. No offense to the Truetime Company, but I really don’t want to mark every TRUE cell with their stock price.
If you use many logical formulas, you will find that there are a lot of false positives in Smart Tags.
In Excel 2002, your only choice was to turn off the Financial Smart Tag. Use Tools – AutoCorrect Options – Smart Tags and uncheck the MSN MoneyCentral Financial Symbols, as shown in Fig. 1279.
In Excel 2003, the smart tag itself now has an option to stop recognizing TRUE as a Smart Tag, as shown in Fig. 1280.
Summary: In Excel 2002, you can turn off the Financial Smart Tag. In Excel 2003 and later versions, you can turn off the Smart Tag for specific values.
Commands Discussed: Tools – Auto correct – Smart Tags
Images
Microsoft Excel: Why Does Excel Mark All My True Cells With An Indicator?
Share to Facebook
Tidak ada komentar:
Posting Komentar