How to Paste as Values in Excel 2013

Last updated: January 19, 2017

Have you ever needed to copy cell values, not formulas? It can be frustrating when you discover that you need a way to only copy and paste cell values in Excel, rather than the formula that is causing those values to display. When you use formulas in Excel 2013 to calculate values that then populate cells, those values are technically stored as formulas that might be referencing other cells.

This is helpful in the original spreadsheet, but becomes complicated if you try and paste those cells to another workbook, worksheet or a different type of document. Typically this will result in something like the image shown below –

example of reference issue in Excel 2013

 

One simple way to fix this is to copy the formulas values, then paste them back into their same cells as values. Once this is done, the cell values are simply numbers, and can be easily copied to whatever location is necessary. However, if you would like to keep the original formulas intact, then you can elect to copy the original cells, then use the Paste Values option when you paste your copied data into separate cells, or a separate worksheet.

 

How to Paste as Values in Excel 2013

Note that using this method will provide you with the option to either overwrite your original formulas with the values that you have copied, or select a different cell into which you would like to paste the copied cell values.

 

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Use your mouse to select the cells containing the formula values that you want to paste to a different document. Note that the formula bar is displaying the formula, not the cell value.

select the cells you want to copy and paste

 

 

Step 3: Press Ctrl + C on your keyboard to copy the selected cells.

 

Step 3b (optional): Select the cell where you would like to paste the cell values, rather than their formulas. If you have copied data from multiple cells, Excel will paste the topmost copied cell into the cell that you select, then fill in the cells underneath it. If you skip this step and leave the originally copied cells selected, then completing the rest of this guide will paste the values into their original cells, which will delete the original formula.

 

Step 4: Click the Home tab at the top of the window.

click the home tab

 

 

Step 5: Click Paste in the Clipboard section of the ribbon, then click the Values option.

how to paste as values in Excel 2013

 

 

Note that the value in the formula bar is now displaying the numerical value instead of the formula. These cells can now be freely copied and pasted from their current location to another document.

cell formula values converted to numerical values

 

 

Summary – How to paste as values in Excel 2013

  1. Select the cell(s) to copy.
  2. Press Ctrl + C on your keyboard to copy the cells.
  3. Select the location where you wish to paste the values.
  4. Click the Home tab at the top of the window.
  5. Click the arrow under Paste, then click the Values option.

 

Do you have a Netflix, Hulu Plus or Amazon Prime subscription, and you’ve been looking for a way to watch those videos on your TV? The Roku 3 can do this, as well as provide access to a lot of other content. Check it out on Amazon for pricing and reviews.

Learn how to print the top row on every page in Excel 2013 to make your printed spreadsheets easier to understand.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.