How to make the company's daily expenditure table in excel

1, open the excel form, write a title in a blank line first, and then fill in the daily consumption content (date, income, expenditure, etc.). ).

2. Organize the table, first set the place to merge, select the cell, and click the center merge at the top of the menu bar.

3. After setting the merge, set the font to bold and centered, and the font color can be selected according to your own requirements.

4. Fill in the date, right-click the selected cell, and then click Set Cell in the option box.

5. Select the date in the small window that appears, and select the desired date mode in the drop-down box at the back.

6. Fill in the date, select the cell, and hold down the mouse to drop it down.

7. Add a title to the table, select the cell merge center, and click bold, font size and color above the menu bar to increase the row height.

8. Select the cell you want to add, add the wireframe to the table, and then click all the wireframes above the menu bar.

9. To calculate the total expenditure, please enter "=C4+E4+G4+I4+K4" in the total cell to be calculated. Just press enter.