On Sun, 15 Jan 2012 16:44:48 +0000, cl@isbd.net said:
So there isn't actually a syntax for "all the way to the end"?
I don't know.
I'd read through the help on relative/absolute column references and saw that it could do some of what I wanted but was hoping for something more straightforward.
Such as?
Isn't there some way of 'auto filling' a column with the same calculation as the previous row whenever a new row is entered into the spreadsheet?
No need. Copy the formula/formulae all the way to the foot of the spreadsheet in one go. That will put the last value of the balance in all the unused rows, but you could easily fix that with an "if" formula. In English: if cell B this row is empty, insert "" else insert the formula I gave before.
If this was a more realistic case where one wanted running balances of "Total including VAT", "Total excluding VAT" and "VAT" it would get very tedious having to make sure the formulae were copied down as one entered new values.
As I say, copy them to the end of the spreadsheet once. Job done.