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.