قالب وردپرس درنا توس
Home / Tips and Tricks / How to Remove Smart Tags from a Workbook in Excel

How to Remove Smart Tags from a Workbook in Excel



  Excel logo

Smart tags can be very useful in Excel to quickly change the action a table performs on your data. They are displayed automatically when you work in Excel, but any smart tag can be removed if you do not use them.

What are smart tags?

A smart tag is a small button that appears when data is entered or selected from a spreadsheet. This button offers actions based on the data in the cells. The following image shows the smart tag insert options displayed when inserting data.

  The Smart Tag Paste Options

When you click the Smart Tag, various paste options are provided.

<img class = "alignnone size-full wp-image-443245" data-pagespeed-lazy-src = "https://www.howtogeek.com/wp-content/uploads/2019/10/xpaste-options -expanded.png.pagespeed.gp + jp + jw + pj + ws + js + rj + rp + rw + ri + cp + md.ic.KMXRp2bsF6.png "alt =" paste options after pasting [19659008] All Smart Tags The options displayed depend on the smart tag and the data in the cells.

They provide a quick way to change the action Excel takes on your data. There are several smart tags in Excel: AutoFill , Flash Fill, error checking, and quick analysis.

Smart tags are temporary, and appear immediately when you select, enter, or paste data into a cell, and they disappear when you perform another task.

How to remove smart tags in Excel

If you do not use smart tags, you can remove them by removing smart tags These are only displayed in Excel when they are switched on again. This change affects all workbooks, not just the currently open ones.

Each of the smart tags in Excel has its own setting that needs to be disabled. This is great because you can disable certain tags that you do not use without removing them all.

Let's take a 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 then clear the "Show Paste Paste Paste Options" check box.

 Prevent insert options from being displayed

This setting removes the smart tag for both the Insert and AutoFill options.

Flash Fill

By default, the Flash fill is done automatically. As you type, Flash Fill may provide suggestions for your data entry.

 Flash Fill automatically offers suggestions

When Flash Fill performs the action, it displays the smart tag so you can undo the suggestions.

 Undo Flash Fill Behavior

If you do not want to continue this Flash Fill behavior, you can disable it. In the Advanced category, clear the Automatic Flash Fill check box.

 Stop Automatic Flash Filling

Error Checking

Excel performs formulas and some basic error checks When you think you've made a mistake, you'll see a green arrow and a Smarttag displayed.

 Error Checking Smart Tag

This does not necessarily mean that you made a mistake. Excel queries the formula because it may be inconsistent or unusual.

In the Formulas category, deselect the Enable Background Check check box.

 Prevent Background Check

Quick Analysis Tools

The Quick Analysis Options smart tag appears when you select a range of values ​​in your spreadsheet. It provides a quick way to create a chart, apply a conditional formatting rule, or use other analysis functions.

 Access quick analysis tools via smart tag

if you do not use this feature You may find it frustrating and want to remove it. In the General category, deselect the Show Quick Analysis Options on Selection check box.

 Disable the function


Source link