Copy & Paste multiple cells with formulas


I'm trying to copy multiple cells from one sheet to another. The original sheet has formulas that tally up data. When I copy these cells, it pastes the results of the formula, but not the actual formula into the cell. Any suggestions on how to get multiple formulas to copy over (rather than copy and paste each individual formula into each individual destination cell)?



Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Have you tried "Paste Special"?

    If so and that is still not working, you can try this:

    Put some random special character that isn't used in any of the formulas as the very first character. This will convert everything into text strings. You can then copy/paste in bulk and finally do a find/replace to remove that special character which will then convert everything back into formulas.

    For example, if you are not using an ! anywhere on the sheet, you can use that like so


    Copy/paste this over then find/replace can remove the !.

    If you do this to all of the cells on the original sheet first, you should be able to copy/paste in bulk.