Tom’s Tutorials For Excel: Pasting a Formulas Static Value in Cell Below
You probably know that if you select a cell below a cell that contains a value or formula, when you press
Ctrl+' (the Ctrl and apostrophe keys), you can replicate that value or formula.
If the cell of interest contains a formula, and you only want to replicate that cell’s value but not its formula, you can press
Ctrl+Shift+' (the Ctrl and Shift and apostrophe keys).
The following pictures illustrate this functionality.