Posts: 515
Threads: 65
Joined: Jun 2018
I have a worksheet which references other worksheets and formulas in all the cells which reference other worksheets. I would like this worksheet with its results to be standalone now. I know there is a command so I get only the hard numbers in the cells, not the formulas. Does anyone remember how to do this? Thanks!
Posts: 26,413
Threads: 741
Joined: May 2025
Reputation:
0
Select all the cells, Copy, Paste Special, Values
If you have formatting you want to keep repeat this, but do:
Select all the cells, Copy, Paste Special, Formats
Posts: 515
Threads: 65
Joined: Jun 2018
Posts: 26,413
Threads: 741
Joined: May 2025
Reputation:
0
Actually, that second item with the formats is only if you are pasting into a different location.
