Chat with us, powered by LiveChat

How to Add Borders in Excel

How to Add Cell Borders and Background Colors in Excel

Adding cell borders and filling cells with colors and patterns is an easy way to make your data stand out, appear more organized, and make the spreadsheet easier to read.

Add a Cell Border

  1. Select the cell(s) where you want to add the border.
  2. Click the Border list arrow from the Home tab.

    A list of borders you can add to the selected cell(s) appears. Use the examples shown next to each border option to decide which border type will work best for you.

  3. Select a border type.
    Format a Number or Date

    To remove a border, click the Border list arrow in the Font group and select No Border.

Advanced Border Options

To have more control over the look and style of the cell borders, use the advanced border options.

  1. Select the cell(s) where you want to add the border.
  2. Click the Font dialog box launcher.
    Advanced Border Options
  3. Click the Border tab.
  4. Select the line style and color you want.

    You now need to specify where you want the new border style to appear.

  5. Select a preset option or apply borders individually in the Borders section.
  6. Click OK.
    Advanced Border Options

The border is applied to the cell range.

Add Cell Shading

  1. Select the cell(s) where you want to add the shading.
  2. Click the Fill Color list arrow.

    A palate of theme colors is displayed in the menu. If you want to use a different color, select More Colors.

  3. Select the color you want to apply.
    Add Cell Shading

A background color is applied to the cell(s). Make sure the background provides enough contrast with the text to be legible.

FREE Quick Reference

Click to Download