Step-by-Step Guide: Eliminating Smart Tags From Microsoft Excel Workbooks

Quick Links

• What Are Smart Tags?
• How to Remove Smart Tags 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.

How to Remove Smart Tags in Excel

If you don’t use smart tags, you can remove them. Removing smart tags will stop them from appearing in Excel until they’re switched back on again. This change affects all workbooks and not just the one that’s currently open.

Each of the smart tags in Excel has its own individual setting that’s required to be disabled. This is great because you can disable specific ones that you don’t use without having to remove them all.

Let’s look at how to remove each smart tag. All smart tags can be removed from the options window in Excel. To open this window, click File > Options.

Paste Options and AutoFill

To remove the Paste Options button, click “Advanced” and uncheck the “Show Paste Options Button When Content Is Pasted” box.

This setting removes the smart tag for both the paste and autofill options.

Flash Fill

By default, Flash Fill is set to occur automatically. As you type, Flash Fill might offer suggestions on your data entry.

If Flash Fill performs the action, the smart tag appears so that you can undo the suggestions.

If you don’t want this automatic Flash Fill behavior to keep happening, you can turn it off. From the “Advanced” category, uncheck the “Automatically Flash Fill” box.

Error Checking

Excel runs some basic error checks as you write formulas, and if they believe you made an error, a green arrow and smart tag appear.

This doesn’t necessarily mean you made an error. Excel is querying the formula because it might be inconsistent or unusual in the way it was used.

From the “Formulas” category, uncheck the “Enable Background Error Checking” box.

Quick Analysis Tools

The Quick Analysis options smart tag appears when you select a range of values on your spreadsheet. It offers a quick way to create a chart, apply a Conditional Formatting rule, or use other analysis features.

If you don’t use this feature, you might find it frustrating and want to remove it. In the “General” category, uncheck the “Show Quick Analysis Options on Selection” box.

Also read: