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.
Post a Comment Blogger Facebook
We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.