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: , , , , , , , , , , ,
3 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

Leave a Reply

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

*