I need to multiply all the numbers in column C times 0.91 (or 91%) to arrive at the correct number for all the numbers in column D. I am able to do that one at a time, but I seem to recall that years ago when I used Microsoft Excel that I could just do a shift and down arrow and do a formula that would hold for the whole spreadsheet. Is there any way to do a similar thing with Open Office Calculator, or am I stuck with having to do each line separately?