J@Y -

Select a single cell, i.e., B1. Then drag down.

- Mike
http://www.mikemiddleton.com

"J@Y" wrote in message
...
My monthly data are in a column. I am currently using B1=Stdev(A1:A3)....
then selecting 3 vertical cells (ie: B1:B3) then dragging it down. But
that
leaves each quarterly Stdev 2 spaces apart. How would I do it so that the
quarterly Stdev organized in 1 spaceless column?