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.

Steps

1
Open an Excel sheet. Double-click on any Excel sheet in your computer to open it up.
2
Select the cells you want a border around. You can do this by clicking and dragging over the cells you want until they turn blue.
3
Click the ▼ down arrow next to the Borders button. 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
Click Thick Box Border to add a border around your selection. Thick Box Border 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.