How Do You Create A Simple Budget Spreadsheet Using Microsoft Excel 2007?
A. To create the different categories you spend money on: 1. Open the Microsoft Excel program on your computer. 2. Click on cell A3 and type the word “Rent”. 3. Press Enter. 4. Type “Bills” inside of A4. 5. Press Enter. 6. Type “Food”. 7. Press Enter. 8. Type “Recreation”. 9. Press Enter. 10. Type “Fuel”. Result: You will have five rows, but parts of some words will have extended beyond the edge of the cell. B. To adjust the width of cells 1. Put the cursor between the A and B cells at the top of the sheet. 2. Click once, then click and hold down the left mouse button, pushing the mouse right. You see that the entire Column A expands right. 3. Expand the cell A right until the words all fit inside of Column A. C. To continue entering information on your budget spreadsheet: 1. Click cell B2. 2. Type “Total Cost”. 3. Press Tab. 4. Type “Checking Account Balance”. 5. Press Tab. 6. Type “Money Used”. 7. Press Tab. 8. Type “Monthly Expenditures”. 9. Press Tab. 10. Type “Available for Emerge
