回複:求助microsoft excel用法

來源: 雞毛蒜皮 2006-07-18 17:31:04 [] [博客] [舊帖] [給我悄悄話] 本文已被閱讀: 次 (537 bytes)
Let's say that you have all the data in colume A.
In colume B, the Cell 100 (B100) type =Sum (A1:A100),
in colume C, the cell 100 (C100) type = STDEV (A1:A100).
If you want some other calculation, do the same in colume D, E,F... ...

Then select Cells (B100, C100, D100,... ..., whatever you have done), Copy (ctrl+C).
Select cell range (b200: XY) x is the letter of the last colume you have used, y is the last data,eg., 29758.
then ctrl p.

Done.

raw 200, 300, 400,... ... are the results you want!
請您先登陸,再發跟帖!