Consider this example. Cell B3 contains the Formula =B1-B2 (see figure below).

This formula evaluates to 200. This ‘200’ is the value of Cell B3. To copy and paste this Value i.e. 200, to the adjoining cell C3, go to cell B3, hit [CTRL + C], or right your mouse and select <Copy> from the shortcut menu that pops up. Go to cell C3 and click <Edit>  <Paste Special>. A [Paste Special] dialogue box shall appear (See figure).  From the various options in the dialogue box, select the third option [Values] and click on <OK>. It’s done! Cell C3 now contains the value 200. In the same way you can copy and paste only the Formats (especially the conditional Formatting applied to a cell), Comments, Validation, etc, by selecting the appropriate button from the [Paste Special] dialogue box.

More Under Finance

Posted Under

Category : Finance (3497)
Type : Articles (14822)
Tags : Excel Tips (35)

0 responses to “Excel Tips – How to Copy Paste only Values from one cell to another?”

  1. SUNIL PATEL says:

    THANKS SACHIN J

  2. sachin j says:

    Dear mr patel

    pls try this formulla for your query.

    +IF(C5<=100000,0,(C5-10000))

  3. SUNIL PATEL says:

    EXCEL 2010 MA  KISIBHI FILE ME EXAMPALE- C5 ME 15000 HE USE C8 ME KASE FORMULA DENI HOGI KI 0 SE 100000 HO TO VALUE 0 HO AUR 100000 SE JYADA HO TO C5 ME JO VALUE HO USME SE 10000 BAD HO JAYE … USKI EXCEL ME TIPS BATANA PLEASE…..

Leave a Reply

Your email address will not be published. Required fields are marked *