Creating copy of my file without formulas

[Domswallow]

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.

[#2]

@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)