Applying Font, Color, and Borders to Cells

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.

Challenge!

  • Open your Monthly Budget file.
  • Bold the words My Budget in row 1, and change the font to Verdana, size 14.
  • Format the other labels (Rent, Car Payment, Insurance, etc.) as Arial, bold, size 10.
  • Use AutoFit to format columns A, J, L, and M.
  • Change the font color of all of your expenses to RED.
  • Change the font color of all of your income to GREEN.
  • Apply at least one border.An example:Challenge 14 Example
  • Save and close the document.