PDF download Download Article PDF download Download Article

An Excel spreadsheet can be formatted in a variety of ways to perform a number of different tasks. Data can be organized and displayed to suit particular needs, and individual cells can be programmed to make specific calculations based on the data entered. Those calculations can then be inserted into graphical representations of the data, such as charts and graphs. This article provides examples on how to format an Excel spreadsheet to organize, calculate and analyze expenses.

Method 1
Method 1 of 3:

Enter the Text for the Expense Tracking Spreadsheet

PDF download Download Article
  1. Type the date into cell A2, "Groceries" in cell B3, "Gas" in cell B4, "Rent" in cell B5, "Utilities" in cell A6 and "Electric" in cell C6. Then type "Water/Sewage" in cell C7, "Phone" in cell C8, and "Cable/Internet" in cell C9.
    • Type "Auto Loan Payments" in cell B10, "Cell Phone" in cell B11 and "Entertainment" in cell A12. Type "Meals Out" in cell B12, "Movies" in cell B13, "Amount" in cell E2 and "Total" in cell E2. The text for the expense tracking spreadsheet has been entered.
  2. Advertisement
Method 2
Method 2 of 3:

Format the Expense Tracking Spreadsheet

PDF download Download Article
  1. Select cells A2 through E2. Click the Merge and Center button on the Alignment toolbar. Click the Fill Bucket in the Font formatting toolbar and select "White, background 1, Darker 35%."
    • Select cells A3 through A5. Press and hold the control key on the computer keyboard and select cells A6 through B9, A10, A11, A12, B12, A13 and B13. Click the Fill Bucket in the Font formatting toolbar and select "White, background 1, Darker 50%."
    • Select cells B3 through D3. Press and hold the control key on the computer keyboard and select cells B4 through D4, and B5 through D5. Continue to hold down the control button and select cells B10 through D10, and B11 through D11.
    • Click the Fill Bucket in the Font formatting toolbar and select "White, background 1, Darker 50%." Click the Merge and Center button, and the right justify button in the Alignment menu on the toolbar.
    • Select cells C6 through D6. Press and hold the control key and select cells C6 through D6, C7 through D7, C8 through D8, and C9 through D9. Click the Fill Bucket and select "White Background 1." With the cells still selected, click the Merge and Center button, and the right justify button in the Alignment menu on the toolbar. Shading and merged cells have been formatted.
  2. Click in cell E13 and click the AutoSum button in the editing menu on the far right of the standard toolbar. Select cells E3 through E13 and select the Currency button ($) in the Number formatting menu on the standard toolbar. Numbers entered into the fields for each category will be displayed as a monetary value, and the total will appear at the bottom of the table. The expense tracking sheet has been formatted.
  3. Advertisement
Method 3
Method 3 of 3:

Create an Excel Pie Chart to Display Expenses

PDF download Download Article
  1. Click the Insert tab on the standard toolbar and click the Pie button. A blank chart will appear in the application window. Click and drag the blank chart to the right so that the entire table is viewable. Click the Select Data button in the Design menu on the Chart Tools toolbar. The Select Data dialogue box will appear. Click the Edit button in the Horizontal Axis Labels column on the right of the dialogue box.
    • Select cells B3 through D13 and press OK. Click the second to last option in the Charts Layout menu, which is "Layout 6." Click in the chart title field at the top of the pie chart and type "Monthly Expenses." The chart has been formatted and will display the amount spent in each category as a percentage of the total.

Community Q&A

Search
Add New Question
  • Question
    How do I format a cell to be the constant in a descending formula?
    Community Answer
    Community Answer
    Pressing f4 locks the reference of a cell. If your formula references the cell after you press f4, it will add $ symbols before the reference. Adding those symbols before both row and column references will lock it in place so that when it starts descending, it will always only reference that cell.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement

Video

Tips

Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!

You Might Also Like

Calculate Average Growth Rate in ExcelCalculate Average Growth Rate in Excel
Format a Cell in Microsoft ExcelEasy Steps to Change the Format of a Cell in Microsoft Excel
Merge Cells in Excel Merge Cells in Microsoft Excel: A Quick Guide
Unprotect an Excel SheetUnprotect an Excel Sheet
Unhide All Rows and Columns in Microsoft Excel
Use If‐Else in Excel Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
Insert Pictures in Excel That Automatically Size to Fit Cells Insert Pictures in Excel That Automatically Size to Fit Cells
Create a Mortgage Calculator With Microsoft ExcelCreate a Mortgage Calculator With Microsoft Excel
Create a Graph in Excel Create a Graph in Excel
Unhide Columns in Excel Show Hidden Columns in Microsoft Excel & Unhide Column A
Ethernet Doesn't Have a Valid IP Configuration Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
Freeze Cells in Excel3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
Change from Lowercase to Uppercase in Excel Change from Lowercase to Uppercase in Microsoft Excel
Make a Spreadsheet in ExcelMake a Spreadsheet in Excel
Advertisement

References

  1. Go with Microsoft, Excel 2007-Comprehensive First Edition, Shelly Gaskin and Karen Jolly. Published in 2008, Pearson Education Inc., Upper Saddle River, NJ.

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 69,900 times.
How helpful is this?
Co-authors: 6
Updated: January 31, 2023
Views: 69,900
Categories: Microsoft Excel
Thanks to all authors for creating a page that has been read 69,900 times.

Is this article up to date?

Advertisement