2 Excel Tips – How to Copy Paste only Values from one cell to another?

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.

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Telegram

taxguru on telegram GROUP LINK

Review us on Google

More Under Finance

0 Comments

  1. 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 Comment

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

Search Posts by Date

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728