How to copy only values in Excel 2013

This tutorial explains the method to copy only values from a cell with formula to another cell.

Step 1: Copy the source cell containing the formula and values. You can either use the keyboard shortcut Ctrl + C or Copy menu option under Home > Clipboard

image

Step 2: Now navigate to the destination cell, click the Paste option under Home > Clipboard

image

Step 3:  From the Paste drop down, select Values under Paste Values section. This should copy only the values to the destination cell.

image

Another alternate method to access the Paste Value option is to right click on the destination cell and cell required option from Paste Options or Paste Special menus.

In Category: Excel 2013, Office 2013

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.