I am using a ledger for simple accounts, Date, Name, Service, Amount
and Total.
The far right column keeps a running total. I have however omitted
some data and am trying to add rows in various places in date order.
I can insert the rows no problem, however, the final right hand cell
remains blank and will not update the total.
I have tried the format painter which works for all cells but the
last, the format bar is greyed out along with anything else I thought
I could use to solve the problem.
I have tried adding the data on the last row and dragging it up to
where I want it but as soon as I move it even one place the final cell
goes blank again...
I'm sure it's something simple and that I have overcome this problem
before but this time it's driving me nuts!