Formatting Cells

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

To add a border:

  1. Select the cells you want to modify.
  2. Click the drop-down arrow next to the Borders command on the Home tab. The border drop-down menu appears.
    Adding a border Adding a border
  3. Select the border style you want to use.

You can draw borders and change the line style and color of borders with the Draw Borders tools at the bottom of the Borders drop-down menu.

To change font color:

  1. Select the cells you want to modify.
  2. Click the drop-down arrow next to the font color command on the Home tab. The color menu appears.
  3. Move your mouse over the various font colors. A live preview of the color will appear in the worksheet.
    Adding a font color Adding a font color
  4. Select the font color you want to use.

Your color choices are not limited to the drop-down menu that appears. Select More Colors at the bottom of the menu to access additional color options.

To add a fill color:

  1. Select the cells you want to modify.
  2. Click the drop-down arrow next to the fill color command on the Home tab. The color menu appears.
  3. Move your cursor over the various fill colors. A live preview of the color will appear in the worksheet.
    Adding a fill color Adding a fill color
  4. Select the fill color you want to use.