I have a huge dataset from which i have created some descriptive
statistics e.g mean, mode, sd, var, skewness (5 columns). These
descriptive statistics themselves create a dataset of about 90 rows * 5
columns. Therefore 450 cells have a formula which creates a value drawn
from the original dataset.

I want to copy column 1-the mean (90 rows), to another spreadsheet. To
present it in a nice table. However when i copy then paste it, it takes
the formulas as well which takes a long time to load. Is it possible
just to take a snap shot of the mean column and paste its raw data
(without the formulas) to the new spreadsheet?

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=504419