How to Apply an Outside Border in Excel

By C. Taylor

Outside borders help separate blocks of data.
i Medioimages/Photodisc/Photodisc/Getty Images

Borders in Excel 2013 help emphasize spreadsheet data and create aesthetic appeal. By separating data from adjacent cells, you improve readability and draw attention to important sections of your Excel spreadsheet. Although any cell can have its own border, it's often more helpful to apply a border to a contiguous block of cells. This outside border creates a box around data groups without adding borders around individual cells. Excel offers a quick option for adding outside borders through it tabbed interface, but for greater control you’ll need to access the Format Cells dialog.

Step 1

Click and drag your mouse cursor around a section of data.

Step 2

Click the "Home" tab, select the "Borders" drop-down menu from the Font group and select "More Borders." Alternatively, to apply a simple outside border, click "Outside Borders" or "Thick Box Borders."

Step 3

Click the type of border line you want in the Style section and select your preferred color from the "Color" drop-down menu.

Step 4

Click "Outline" and select "OK" to apply an outside border.

×