Anyone use Appleworks? (1 Viewer)

[Anthony]

I have a spreadsheet question. I'm sure there's a simple answer but spreadsheets freak me out. See if you can follow this...

D4 is x, E4 is =D4*.21, F4 is =D4+E4
simple yes?

How do I put those functions on the whole page, like the entire E and F colums without doing it manually?

Thanks

 

[the bongo]

If the sum is on the same row as the two boxes your multiplying, you should be able to copy that cell then select a lot of cells at once on the same column and paste. It should then paste the sum into all the cells and adjust for the change in row number - at least, it has been doing that for me.

 

[Anthony]

Great, I'll try that.

 

[Anthony]

I must be doing it wrong. It's not working.

 

[the bongo]

Sorry, I'm an idiot, I was thinking of numbers in iwork.

 

[Anthony]

yea, it's high time I upgraded my spreadsheet. What's numbers like?

 

[the bongo]

it functions, that's as far as i go. it does things like the above.