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
How to do this horizontally?
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.