apply a formula to a whole column
In a Pages report I have a column of figures (column A) and I want to multiply each of them by 15 into column B. So what I want is something that finishes up looking like this:
A B
1 15
2 30
6 90
4 60
Now I can go to every cell in column B and write "15* ..." and click on its neighbor in A and get this, but what I want is a way to make the whole column do it all at once. The Help explanation may tell me how to do this, but I can't figure it out from what they say there; copying and pasting isn't working either. Can someone give it to me in English?
A B
1 15
2 30
6 90
4 60
Now I can go to every cell in column B and write "15* ..." and click on its neighbor in A and get this, but what I want is a way to make the whole column do it all at once. The Help explanation may tell me how to do this, but I can't figure it out from what they say there; copying and pasting isn't working either. Can someone give it to me in English?
MacBook, Mac OS X (10.6.2)
