Tom’s Tutorials For Excel: Pasting a Formulas Static Value in Cell Below

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.





Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , ,
5 comments on “Tom’s Tutorials For Excel: Pasting a Formulas Static Value in Cell Below
  1. Pat Constant says:

    TOm
    The first part works fine. I cannot get the second part to work. I thought it was my keyboard, but no luck on another computer. It would be very useful for me if it worked
    Any suggestions
    Pat

    • Tom Urtis says:

      What exactly happens that leads you to say the second method does not work? Is it that nothing happens? Or something happens — if so, what — but not the expected result?
      I just tested it again now and it worked fine for me. Example:
      In cell A1 I entered 5
      In cell B1 I entered 3
      In cell D6 I entered the formula =A1+B1 and as expected, I get 8 returned by that formula in cell D6.
      I selected cell D7
      I press Ctrl+Shift+’ (Control + Shift + apostrophe) and 8 is entered there in cell D7 as a static value.

      When you follow those steps, what do you see happening?

  2. Pat Constant says:

    Tom

    Apologies Just seen your reply of last October You are correct. My keyboard (UK) is slightly different from American keyboard When I press Ctrl Shift 2 it works perfectly because my shift 2 is the ” symbol and my shift + ‘is the “@” symbol the opposite of yours

    Thanks a million

    Pat

  3. hussain munshi says:

    How to do this horizontally?

    • Tom Urtis says:

      One way is to drag the cell to the right using your right mouse button pressed upon the edge of the cell being dragged. Release the right mouse button and Copy Here as Values Only.

Leave a Reply

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

*