How Do I Add Borders to Cells in Microsoft Excel?

Excel 2013 and 2010 include a set of basic border and underline styles, available through a drop-down menu on the home tab. To add more complex borders that include a variety of styles and colors, create a new cell style. User-made styles carry over between all workbooks on your computer, making it possible to apply the same border pattern to cells in several files without redrawing the border every time.

...
Some built-in heading presets include borders or underlines.

Add Simple Borders

Step

Select a range of cells to modify and open the drop-down menu next to the border icon in the Font group of the Home tab.

...
Select the cells that need a border.
...
Choose a border style.

Step

Choose any border style to apply a border around the selected cells. Most styles add borders around the extremity of the selected area, but the "All Borders" style draws border lines between each cell in the selected area.

...
Add additional borders.

Step

Select another cell or group of cells and click the border icon to apply the last-used border style to additional cells. To use a different border style, open the drop-down menu again and pick a new style.

Create Border Styles

Step

Click the "More" arrow in the Styles section of the Home tab.

...
Open the style selector.
...
Create a new style.

Step

Press "New Cell Style" to create a new style preset.

...
Choose style components.

Step

Enter any name for the new style and uncheck all options except for "Border." If you leave other options checked, the selected style components become integrated into the style and would overwrite the formatting on your cells. Press "Format" to begin creating a custom border in the Format Cells window.

...
Draw a border.

Step

Choose a line style and color from the left side of the Border tab and click the box surrounding the sample text to draw border lines. Combine several styles by selecting a different style before drawing each line. When you finish, press "OK" on both open windows.

...
Add your custom border.

Step

Select a cell or range of cells and click your new style in the Styles section to apply the border.