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

Instead of the ordinary Paste, you need to use Paste SpecialValues

"cj21" wrote:


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

Hi
You need to use pastespecial
after coping when in new spreadsheet goto edit pastespecial click values
then ok
this copies value of each cell not its formula
Tina

"cj21" wrote:


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