I'm an Excel beginner working my way through the Chandoo videos and I have a really simple question that I haven't been able to find the answer to. I'm really sorry to post such a simple question on here but I've spent over an hour on google searching and still can't find the answer.
I am using a table in an Excel (2007) spreadsheet to calculate an expense report. Row 1 has the titles (date, balance, cost, etc.). Column A is the date, Column B is my balance, and Column C is the cost of the item, etc. So B2 is my initial balance and C2 is the cost of the first item I purchased. I record the cost of each item in the C column, and B3 is the formula =B2-C2, B4 is =B3-C3, and so on and so forth. The problem is that every time I add a new expense in, a new row in the table is created and the default value is my initial balance (the value in B2), and then I have to click on the previous B cell and drag it down to make the formula carry over. I don't want to have to do this every time I add a new expense--I want to add the new expense in the C column and have the B cell in the same new row automatically calculate the formula rather than display the initial value (B2).
Thanks!
I am using a table in an Excel (2007) spreadsheet to calculate an expense report. Row 1 has the titles (date, balance, cost, etc.). Column A is the date, Column B is my balance, and Column C is the cost of the item, etc. So B2 is my initial balance and C2 is the cost of the first item I purchased. I record the cost of each item in the C column, and B3 is the formula =B2-C2, B4 is =B3-C3, and so on and so forth. The problem is that every time I add a new expense in, a new row in the table is created and the default value is my initial balance (the value in B2), and then I have to click on the previous B cell and drag it down to make the formula carry over. I don't want to have to do this every time I add a new expense--I want to add the new expense in the C column and have the B cell in the same new row automatically calculate the formula rather than display the initial value (B2).
Thanks!