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.

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.

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.