Populate y col from x col values

  • Thread starter Thread starter aquaflow
  • Start date Start date
A

aquaflow

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
 
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
 
Back
Top