Skip to main content
Workforce LibreTexts

4.6.2: Intro- Interface- Smart Tags/Actions

  • Page ID
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    Other 'Smart' Buttons in Excel

    Excel has some similar buttons of its own which have options menu. The exact options may vary depending on exactly what you just did.

    • Button: AutoCorrection Options (Excel 2010) AutoCorrect Options
      When Excel applies an AutoCorrection, the AutoCorrect Options button appears. Its menu offers to undo the autocorrection. You can even make Excel stop doing this type of autocorrection.
    Button: AutoCorrect menu - hyperlink (Excel 2010)
    • Button: Paste Options (Excel 2010) Paste Options
      The choices that appear for pasting depend on what you have copied and whether it was already inside your spreadsheet or not. Office 2007 and 2010 use icons to illustrate the choices. Hovering over an icon makes a screen tip appear about the icon. 

      The examples below are for pasting from inside Excel, from a web page, and a picture from a Word document.

    Button: Paste Options - menu dropped (Excel 2010)
    Button: Paste Options - 14 options (Excel 2016)
    Button: Paste Options - copy from web page (Excel 2010)
    Button: Paste Options from web page (Excel 2016)
    Button: Paste Options - picture (Excel 2010)
    Button: Paste Options - pasting from Word (Excel 2016)

    Copy and paste: from inside Excel, from a web page, a picture from a Word document

    • Paste  Paste
    • Paste formula  Paste the formula
    • Paste formula and number formatting  Paste the formula and number formatting
    • Paste - Keep source formatting  Keep source formatting
    • Paste - Match Desitination Formatting (Excel 2010)  Match destination formatting
    • Paste - No borders  No borders
    • Paste - Keep source column widths  Keep source column widths
    • Paste - Transpose rows and columns  Transpose - rows and columns


    • Paste values only  Values only
    • Paste values and number formatting  Values and number formatting
    • Paste values and keep source formatting  Values and source formatting


    • Paste formatting only  Paste formatting only
    • Paste link  Paste as a link
    • Paste as a picture  Paste as a picture
    • Paste as a linked picture  Paste as a linked picture
    • Button: AutoFill Options (Excel 2010) Auto Fill Options

    When you drag the Fill handle (the small blank square in the bottom right corner of the selected cells), Excel looks to see if there is a pattern to the values you selected. If it sees one, it will can extend the series into the new cells.
    The AutoFill Options menu gives you the choice of filling the series (which also includes the formatting) or just the formatting or filling the series without the formatting. The example at the right also includes Fill Months because Excel thinks that the text is months of the year.

    Button: AutoFill Options (Excel 2010)
    • Button: Insert Options (Excel 2010) Insert Options

    When you insert a cell or a row or a column, how do you want the inserted part formatted? Menu items vary depending on what you are inserting.

    Button: Insert Options - cell (Excel 2010)
    Button: Insert Options - row (Excel 2010)
    Button: Insert Options - column (Excel 2010)

            The illustrations are for a cell, a row, and a column.

    • Button: Trace Error Options (Excel 2010) Trace Error Options
      A green triangle in upper left of cell means that Excel thinks your formula has an error. Click in the cell and then on the Trace Error icon. The menu should give you a hint about what the problem is.
    Button: Trace Error Options menu (Excel 2010)
    Button: Trace Error Options - omits adjacent cells with numbers (Excel 2010)


    Error Description Example
    #NAME? Typing error
    Typing a range name that does not exist
    Leaving off the quotation marks around a text string in a formula
    =SUMN instead of =SUM

    = Total is&B44 instead of ="Total is "&B44
    #DIV/0! Tried to divide by zero. Either the cell's value was zero, it was blank, or it contained text instead of a number.
    Numbers that are formatted as text can cause this, too.
    #VALUE! Tried to do something to data of the wrong type, like trying to add values when at least one is text instead of a number. = 4 + "total"
    ="Total = "& 6
    #REF! Formula refers to a cell that you deleted or pasted over.  
    #NUM!  Problem with a number in the formula.
    An argument is invalid.
    A calculated value is too large or too small to display.
    =DATE(-72, 3, 15)  which has as the year 72 BC. The DATE function cannot handle a negative number for the year.

    a value less than
     -1*10307 or greater than 1*10307
    #NULL!  The formula includes multiple ranges with a space in between instead of a comma, but the ranges do not overlap. When the ranges do overlap, the formula uses only the values from the intersection of the ranges. =SUM(B7:B13 C7:D8)
    Formula Omits Adjacent Cells This one may not actually be an error! It depends on what your formula is supposed to do. The warning helps when your dragging missed a cell or two.  


    4.6.2: Intro- Interface- Smart Tags/Actions is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?