Copied From Above
Here’s a super quick copy trick for MS Excel!
Have you ever needed an exact copy of a cell’s contents?
And I do mean exact. Even cell references won’t be changed in your formulas.
Well, here’s the trick: simply select the cell directly below the item to be copied and use the Ctrl + ‘ (Ctrl + apostrophe) key combination.
Yep, that’s all there is to it! The cell contents are duplicated and can now be moved to whatever location you choose.
And those cell references in your formula? Well, unlike the results from the usual copy/paste, this method leaves them exactly as they were.
Now, that’s what I call a true copy!