expense budget template

G

Guest

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?
 
C

Conan Kelly

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 (Edit>Fill>Down or [Ctrl] + D ).

I hope this helps,

Conan Kelly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top