How do I perform a different formula on the same cell range?

[erinlm]

I would like to first take the mean of a column of data, then the standard
deviation of the same data. The two ways I have thought of doing this are
(for example):
1. First type AVERAGE and highlight (A1:A5) then copy the text (A1:A5) and
paste it in the next cell and type STDEV
2. First type AVERAGE and highlight (A1:A5) then go back and put in the
absolute reference dollar signs ($A$1:$A$5) then fill across to the next cell
and then change to STDEV
Both are getting tedious and too repetitive for the number of times I need
to do this, while I think the length of the column changes too often to
create a macro.
Any suggestions? Thanks!

 

[ryguy7272]

Would you consider using a Pivot Table?
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html#Multiple

Regards,
Ryan---

 

[Spiky]

I would like to first take the mean of a column of data, then the standard
deviation of the same data. The two ways I have thought of doing this are
(for example):
1. First type AVERAGE and highlight (A1:A5) then copy the text (A1:A5) and
paste it in the next cell and type STDEV
2. First type AVERAGE and highlight (A1:A5) then go back and put in the
absolute reference dollar signs ($A$1:$A$5) then fill across to the next cell
and then change to STDEV
Both are getting tedious and too repetitive for the number of times I need
to do this, while I think the length of the column changes too often to
create a macro.
Any suggestions? Thanks!

If you do virtually the exact same calculation frequently in different
files, why not just save a blank copy with your formulas in place and
reuse from there? You can add rows very quickly for different length
columns. Or use a dynamic named range which will always pick the full
column of data.

Also, do you know how to copy with the mouse? Click and drag from the
lower right corner of the cell you want to copy. Usually much faster
than Copy/Paste with other methods.

3rd speed item; while you are entering the range, press F4 to toggle
between all the $ absolute reference choices quickly. Faster than
manually typing each $.