Paste results into cell without formulas

Excel 365 2016 2013 2010 2007
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 (group of cells), use the Edit -> Paste Special... command.

Paste Special in Excel 2003
  • All: Equivalent to using the Edit -> 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 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.

The option buttons in the Operation section of the Paste Special dialog box let perform an arithmetic operation.

For example, you can copy a range to another range and select the Multiply operation. Excel multiplies the corresponding values in the source range and the destination range and replaces the destination range with the new values.

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.

Pasting pictures of cells and charts

Pasting pictures of cells and charts

One of Excel's best-kept secrets is its ability to copy and paste pictures of cells. You can copy a cell or range and then paste a picture of the cell or range on any worksheet or chart.
Using Solver

Using Solver

Solver tool allows you to specify multiple adjustable cells and constraints on the values that the adjustable cells can have, generate a solution that maximizes or minimizes a particular worksheet cell, generate multiple solutions to a problem.
Grouping and ungrouping sheets

Grouping and ungrouping sheets

Sheets can be grouped (connected) to facilitate creating or formatting two or more identical sheets. For example, you can create one sheet and copy it to two other sheets, or you can group three blank sheets and enter and format the content once-no subsequent copying required.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more