**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.

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

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?

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