How to Remove Smart Tags from a Workbook in Excel
Smart tags can be very useful in Excel to quickly change the action a spreadsheet performs on your data. They appear automatically as you work in Excel, but each smart tag can be removed if you do not use them.
What Are Smart Tags?
A smart tag is a small button that appears as data is entered or selected on a spreadsheet. This button provides actions based on the data in the cells. The image below shows the Paste Options smart tag that appears when data is pasted.
When the smart tag is clicked, different paste options are provided.
All smart tags work in this way. The options you see will be dependent upon the smart tag and the data in the cell(s).
They provide a quick way to change the action that Excel performed on your data. Excel has a few available smart tags: Paste Options, AutoFill, Flash Fill, error checking, and Quick Analysis.
Smart tags are only temporary. They appear immediately as you select, type, or paste data into a cell. They disappear as soon as you perform another task.