i downloaded the template for the expense budget and it has five columns:
item, budget cost, actual cost, difference($) and difference(%). This is
exactly what i need except there aren't enough rows for all my items. i have
tried everything but when i add more the two difference columns don't
transfer. how can i solve this?

sheptoy,

Where did you download this from? What is the link to the website?

The 2 "Difference" columns are most likely formulas that automatically calculate the difference from the values you enter into
"Budget Cost" and "Actual Cost".

When you inserted more rows, the formulas did not copy down into the new rows. You have to copy/fill them down manually.

Select on or both of the "Difference" cells in the row directly above all of the new rows you have inserted. Now expand your
selection to include the cells in the "Difference"
column(s) in all of the new rows you have inserted. Now you can Fill Down (EditFillDown or [Ctrl] + D ).

I hope this helps,

Conan Kelly




"sheptoy" wrote in message ...
i downloaded the template for the expense budget and it has five columns:
item, budget cost, actual cost, difference($) and difference(%). This is
exactly what i need except there aren't enough rows for all my items. i have
tried everything but when i add more the two difference columns don't
transfer. how can i solve this?