How to Insert Borders in Excel

Co-authored by wikiHow Staff

This wikiHow teaches you how to insert borders in your Excel sheets. To add a border, you'll need to select the cells that you want to add a border around, click the border icon, and then select the border that you want to insert.

1

Open your spreadsheet.

Double-click on any Excel sheet in your computer to open it up. If the worksheet with the cells you want to add borders to isn't visible, click its tab once the workbook is open.

2

Select the cells you want a border around.

Click and drag over the cells you want until they turn blue. This selects the cells.

3

Click the down-arrow next to the "Borders" button.

You'll see the ▼ next to "Borders" in the toolbar. The Borders button looks like a square with four quadrants. It’s next to the underline button on the Font group underneath the Home tab.

4

Select "Thick Box Border."

This option creates a border around the outside edges of all the cells you selected. You can choose any kind of border from the drop-down menu.
- If you want borders around each individual box or cell, select All Borders from the drop-down menu instead.
- If you want more formatting options for your border, such as line thickness or color, select those options near the end of the drop-down menu.
- You can also click More Borders at the end of the drop-down menu then select the Border tab to edit the border settings further.
- If you want to remove a border just highlight it again and select No Border from the Border button drop-down menu.