Paste results into cell without formulas

Excel 365 2013 2010 2007 2003
You may not always want to copy everything from the source cells to the destination cells. For example, you may want to copy only the current values of formulas rather than the formulas themselves.

To control what is copied into the destination range (a group of cells), on the Home tab, in the Clipboard group, click Paste, and then do one of the following:

  • Select one of the buttons:
    Clipboard group in Excel 2016

    Paste group:

    • Paste All in Excel 2016   Paste (P): - Pastes the cell's contents, formats, and data validation from the Windows Clipboard
    • Paste Formulas in Excel 2016   Formulas (F): - Pastes formulas, but not formatting
    • Paste Formulas and Number formatting in Excel 2016   Formulas & Number Formatting (O): - Pastes formulas and number formatting only
    • Paste Keep source formatting in Excel 2016   Keep Source Formatting (K): - Pastes formulas, and all formatting
    • Paste No borders in Excel 2016   No Borders (B): - Pastes everything except borders that appear in the source range
    • Paste Keep column width in Excel 2016   Keep Source Column Width (W): - Pastes formulas, and also duplicates the column width of the copied cells
    • Paste Transpose in Excel 2016   Transpose (T): - Changes the orientation of the copied range. Rows become columns, and columns become rows. Any formulas in the copied range are adjusted so that they work properly when transposed

    Paste Values group:

    • Paste Values in Excel 2016   Values (V): Pastes the results of formulas. The destination for the copy can be a new range or the original range. In the latter case, Excel replaces the original formulas with their current values
    • Paste Values and Number formatting in Excel 2016   Values & Number Formatting (A): - Pastes the results of formulas, plus the number formatting
    • Paste Values and Source formatting in Excel 2016   Values & Source Formatting (E): - Pastes the results of formulas, plus all formatting

    Other Paste Options group:

    • Paste formatting in Excel 2016   Formatting (R): - Pastes only the formatting of the source range
    • Paste Link in Excel 2016   Paste Link (N): - Creates formulas in the destination range that refer to the cells in the copied range
    • Paste Picture in Excel 2016   Picture (U): - Pastes the copied information as a picture
    • Paste linked Picture in Excel 2016   Linked Picture (I): - Pastes the copied information as a "live" picture that is updated if the source range is changed
  • Click Paste Special... to open the Paste Special dialog box:
    Paste special in Excel 2016

    Paste group:

    • All: Equivalent to using the Paste command. It copies the cell's contents, formats, and data validation from the Windows Clipboard.
    • Formulas: Only formulas contained in the source range are copied.
    • Values: Copies the results of formulas. The destination for the copy can be a new range or the original range. In the latter case, Excel replaces the original formulas with their current values.
    • Formats: Copies only the formatting.
    • Comments: Copies only the cell comments from a cell or range. This option doesn't copy cell contents or formatting.
    • Validation: Copies the validation criteria so the same data validation will apply.
    • All using Source theme: Pastes everything, but uses the formatting from the document theme of the source. This option is relevant only if you're pasting information from a different workbook, and the workbook uses a different document theme than the active workbook.
    • All except borders: Copies everything except any borders that appear in the source range.
    • Column widths: Copies column width information from one column to another.
    • Formulas and number formats: Copies all formulas and numeric formats, but no values.
    • Values and number formats: Copies all current values and numeric formats, but not the formulas themselves.
    • All merging conditional formats: Merges the copied conditional formatting with any conditional formatting in the destination range. This option is enabled only when you are copying a range that contains conditional formatting.

    Operation group: Let you perform an arithmetic operation on values and formulas in the destination range. This feature also works with a single copied cell, pasted to a multi-cell range.

    Skip blanks: Prevents Excel from overwriting cell contents in your paste area with blank cells from the copied range. This option is useful if you're copying a range to another area but don't want the blank cells in the copied range to overwrite existing data.

    Transpose: Changes the orientation of the copied range. Rows become columns, and columns become rows. Any formulas in the copied range are adjusted so that they work properly when transposed.

See also this tip in French: Coller les résultats dans une cellule sans formules.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.