Setting Up Budget Categories

• 1). Start Microsoft Excel and open a new spreadsheet.
  
  
• 2). Click on A1 cell and enter Categories. Press the Enter key.
  
  
• 3). Enter the word Income in cells A2 and A3.
  
  
• 4). Enter the word Living in cells A4 through A10.
  
  
• 5). Enter the word Other in cells A11 through A15.
  
  
• 6). Enter the word Description in cell B1. Press the Enter key.
  
  
• 7). Enter, in cells C1 through H1, the months January through June.
  
  
• 8). Drag over the first row.
  
  
• 9). Click B (boldface icon) on the toolbar.
  
  
• 10
  
  Drag over the first column.
  
  
• 11
  
  Click B (boldface icon) on the toolbar.
  
  
• 12
  
  Drag over the cells B2 and B3.
  
  
• 13
  
  Enter the name(s) of people earning income in your household.
  
  
• 14
  
  Drag over the cells B4 and B10. This highlights the B cells for the Living categories.
  
  
• 15
  
  Enter Rent, Food, Water, Trash, Gas, Electric, and Telephone in these cells. (Substitute other descriptions depending on your needs.) Press the Enter key after each entry.
  
  
• 16
  
  Drag over the cells B11 and B15. This highlights the B cells for the Other categories.
  
  
• 17
  
  Enter Books, Tuition, Transportation, Medical, and Housekeeping in these cells. (Substitute other descriptions depending on your needs.)