How To Copy From Cell Directly Above Using Ctrl Apostrophe In Excel

Here is how to use the keyboard shortcut Ctrl + Apostrophe to copy data or formulas from the cell above.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , ,

One Response to How To Copy From Cell Directly Above Using Ctrl Apostrophe In Excel

  1. Meni Porat December 22, 2014 at 5:45 pm #

    Hi Michael,
    If you have a formula in the cell above, pressing: CTRL+Apostrophe (CTRL+’) – copies the FORMULA.
    However, if you want to copy the Formula’s VALUE, not the formula itself, use: CTRL+SHIFT+’
    Otherwise, the CTRL+’ works as explained.

    Best Regards,
    Meni Porat

Leave a Reply