+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: dumb excel question (/showthread.php?tid=20434)
dumb excel question - troywellbuilt - 10-12-2006
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!
Re: dumb excel question - davester - 10-12-2006
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
Re: dumb excel question - troywellbuilt - 10-12-2006
Thanks, davester!
Re: dumb excel question - davester - 10-12-2006
Actually, that second item with the formats is only if you are pasting into a different location.