Post # 1
So my wonderful father made me a fantastic excel sheet for my budget…it automatically adds costs to the total and has an automatic conversion rate into different currencies in different columns(my budget is in pounds, but prices for my mexican DW come in both pesos and dollars)
i need to add more lines as there are expenses i forgot about when he helped me with it. how do i add the formula to the extra lines? as right now, when i add numbers it doesnt change the total
unfortunately my dad is away and i cant for the life of me work out how to do it!!
Post # 3
All you need to do, is edit the formulas to include the new lines you added. There is probably a sum formula so that is probably the one you need to add the lines that you added in. Next time you want to add a line, you should be able to add one in the middle of the list of expenses and the formulas should automatically include it.
Post # 4
the easiest way is to add the rows, click on the column above where you want the formula copied to (one hat already has the formula entered into) place your cursor on the bottom right corner- it should change from the pointer to a black cross. simply click and drag down as many rows as you need. this will copy the formula.
If you already have a figure typed in the copied cell, simply delete from the added cells. the formula will not be deleted