Insert rows in Excel Ledger problem

[Gary Huston]

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!

[Daryl S]

Gary -

If your right-hand column contains a formula to keep the balance right, then
when you insert a row, you need to insert that forumula also. The format
painter does not insert data or formulas. Depending on the formula, you may
be able to just copy it from the cell above and paste it into the right-hand
column of the inserted cell. You probably need to re-copy it to the cell
below the new one also, and possibly down the entire column. This all
depends on what the formula is.

Try copy/pasting the formula and check the results carefully. If there are
any problems, paste the formula into your next posting so we can help more.

--
Daryl S

"Gary Huston" wrote:

> .
>

[Gary Huston]

Thanks, but I have sorted it out.
I think the ledger was corrupt, I opened a new one, customized it to y
needs and simply pasted all my data into it.
Now when I insert a row it automatically insert all relevant formulas.
The old one kept saying formulas not used in ledgers!

Thanks anyway.
Gary