If you double click on the little square, the cell will fill down as far as
the column to the left is not blank.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Heidi" wrote in message
...
I think you are looking for the "fill down" command.

Basically, type your formula into the first Y column (=Sum(X1)*180).
Then,
notice that the cell you are in has a dark bold outline and a square at
the
lower right corner . Click that little square and drag down to the end.

This will probably do the trick, but you might want to do a quick google
search on "absolute vs. relative references" for some more info that
might
be helpful.

Heidi

"aquaflow" wrote:

I have values in X col and would like Y col to be populated based on X.
like SUM(X1)*180. How can i do that ? since the col had 900 rows its
tedious task.