If you're working with a spreadsheet program, add a formula at the bottom of each column to calculate total expenses in all categories for each month.

Setting up the spreadsheet in this manner will permit you to add new operating expenses and change current operating expenses, while cell C2 will always display your total.

I have created a macro for my weekly expense tracker that automatically adds column headers, necessary formulas in specific cells (such as SUM to calculate total expenses), and formatting ...

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.