How to make living expenses table with excel

1. Open Excel, list all revenue and expenditure items, then enter a total income formula =SUM(B3:B 15) at the bottom, and then press enter.

2. After listing the total income formula, enter the total expenditure =SUM(C3:C 16), enter the formula, and press enter.

3. After listing the formulas, select several cells in the title, and then click Merge Center.

4. After the header is merged and centered, select all cells and click all borders.

5. After entering the table and entering the line, you can enter the revenue and expenditure details. If you don't enter one item, the total amount at the bottom will change accordingly.