"Using Excel 2010 Smart Tags in Your Excel Work!"


The Excel 2010 smart tags is a special icon that appears when you perform certain Excel tasks, such as pasting data and using the AutoFill feature.

With the smart tags feature, you can make your Excel work faster and easier. This article will demonstrate how to use this feature with Excel 2010.

Generally, clicking the smart tag displays a list of options that enable you to control or modify the task you just performed. Some smart tags appear automatically in response to certain conditions. For example, if Excel detects an inconsistent formula, it displays a smart tag to let you know.

This tutorial will let you know the overview on how to use the smart tag so that you will know how to utilize it when the smart tag options appear while working in a worksheet.


To work with Excel 2010 smart tags

  • Perform an action that displays a smart tag, such as copying and pasting data or object in a cell. We will look at how to copy and paste data in the worksheet.
  • Once you pasted the data, the smart tag appears (as shown below).
  • Excel 2010 smart tag
  • Click the smart tag or press the Ctrl key and it will displays a list of its options.
  • Excel 2010 smart tag options

  • Click the option you want to apply. Excel 2010 applies the option to the task you performed in the first step.


Related Topics:

What are the Excel 2010 Three Different Views?

Applying Gallery Effects to The Spreadsheet Objects in Excel 2010



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2010 smart tags info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Resources:

Click on the image to view the details of the training/book.
Excel 2010 formulas ebook
Microsoft Excel 2010 Formulas


Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.