![household budget excel household budget excel](https://i.pinimg.com/736x/a2/2a/44/a22a4424b2f6bf4cecb00045c21e2eff.jpg)
![household budget excel household budget excel](http://exceltemplates.net/wp-content/uploads/2013/02/Monthly-Budget-Planning-Excel-Template1.jpg)
Delete the formulas from O7, O17, O24, O32, and O38. Use the Totals tab in the Quick Analysis tool to add the SUM to Column O.In the rows for Income #1, Income #2, Mortgage/Rent, Homeowners/Rent Insurance, Car Insurance, Car Payment, and Gym Fees/Memberships, copy the values for January to the cells for February through December.
![household budget excel household budget excel](https://pdfliner.com/ckeditor/images/eUXgMhFCJjOVLw7IJcTChlBHkLSwcvM7KBTqvZnc.png)
Next you need to complete the monthly values for some of the income and expense items.Bold and center align all of the headings in Row 2.Adjust column widths as needed to fit the names of the months in these columns. Using the text in cell C2, use Autofill to fill in the months February through December in cells D2:N2.O2 Yearly Total (adjust column width as needed to fit this text) Insert two new rows at the top of the worksheet.Open the file named PR3 Data and then save it as PR3 Redding.They have started their budget spreadsheet, but they need your help with it. They want to use Excel to examine their household budget. They are trying to decide if they can afford to move to a better apartment, one that is closer to work and school. Etta works as a marketing manager at a clothing company in North Portland. Lucian works part time and attends the local community college. Etta and Lucian Redding are a recently married couple living in Portland, Oregon.