There are a number of ways to format an excel spreadsheet.Individual cells can be programmed to make specific calculations based on the data entered into the system.Charts and graphs are graphical representations of the data.This article shows how to format an excel spreadsheet to organize, calculate and analyze expenses.
Step 1: The text needs to be entered.
The date can be typed into cell A2, "Groceries", "Gas" and "Rent" in the same cell.Then you can type "Cable/Internet" in cell C9.In cell B10, "Cell Phone", and "Entertainment" you can type "Auto Loan Payments"."Movies", "Amount," and "Total" can be typed in cell B12, B13, and E2 respectively.The spreadsheet text has been entered.
Step 2: You can format the cells and text.
Cells A2 through E2 should be selected.The Alignment toolbar has a button for the Merge and Center.Select "White, background 1, Darker 35%" from the fill bucket.Cells A3 through A5.You can press and hold the control key on the keyboard.Click the fill bucket and select "White, background 1, Darker 50%."Cells B3 and D3 can be selected.You can press and hold the control key on the keyboard.Hold down the control button and select the cells you want.Select "White, background 1, Darker 50%" from the fill bucket.The right justify button is on the Alignment menu.Cells C6 through D6 should be selected.Hold the control key and press and hold the cells you want to select.Select "White Background 1" from the fill bucket.The right justify button is on the Alignment menu if the cells are still selected.Cells have been formatted.
Step 3: To add the totals for each category, program the "total" cell.
The autosum button can be found in the editing menu on the far right of the standard toolbar.The Currency button can be found in the Number formatting menu on the standard toolbar.The total will be displayed at the bottom of the table when the numbers are entered into the fields.The expense tracking sheet has been formatted.
Step 4: You can create a pie chart.
Click the Pie button if you want to insert it.There is a blank chart in the application window.The entire table can be seen if you drag the blank chart to the right.The Select Data button can be found in the Design menu.The dialogue box is called Select Data.The horizontal axis labels column has a button on the right of it.The second to last option in the Charts layout menu is "Layout 6."You can type "Monthly Expenses" in the title field at the top of the pie chart.The amount spent in each category will be shown on the chart as a percentage of the total.