Spreadsheet formulas

Copper Contributor

For years, I have done my budget using a spreadsheet. One spreadsheet per year, one sheet per month. At the end of the month, I copy the last sheet into the next new sheet. For example, the Nov. sheet into the Dec. sheet, and rename the new sheet. I then clear all amounts on the new sheet, allowing the totals to revert to zero to start over again with the next month. As of last month when I did this, the totals didn't change when I cleared the column amounts under each of the budget headings. I've tried everything. The totals remain the same even if I clear the columns down to nothing. I've tried creating a new spreadsheet entirely and the same thing happens. Please help!

1 Reply

@smuggler0427 

Make sure that Calculation Options is set to Automatic in the Calculation group of the Formulas tab of the ribbon.