Forum Discussion

Domswallow's avatar
Domswallow
Copper Contributor
Feb 08, 2023

Creating copy of my file without formulas

I am trying to create a copy of my file with just the values and no formulas.

 

I have tried copying and pasting using the paste special function, but I have merged columns so this is bringing up an error message when I try to paste.

excel
Formulas and Functions

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Feb 08, 2023

    Domswallow 

    Without more precise information about the digital environment (Excel version, operating system, storage medium, etc.) as well as the file (without sensitive data) or photos of the worksheet what exactly is meant, I can only give imprecise solution suggestions.

     

    Copy the worksheet to a new one
    Copy with CTRL+C the source worksheet

    and paste it into the target worksheet with Paste Options -> Values.

     

    Could also be done with VBA, but without precise information I can only guess.

     

    Hope I could help you with these information / links.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources