How to Change Cell Border Color in Excel 2013

Organizing and sorting data in Microsoft Excel is a crucial element of creating a spreadsheet that is easy to read and understand. Using borders to separate data is a great way to do this, but you can run into organizational issues when you add borders of the same color to multiple sections of your document.

Fortunately you can change your border colors in Excel 2013 to more easily distinguish between different sets of data and help your readers better understand the information that they are viewing.

 

How to Color a Cell Border in Excel 2013

There is a difference between the gridlines that are on your spreadsheet by default, and cell borders that you add to the spreadsheet. The steps in this article will show you how to add borders to a selected group of cells, then change the color of those borders. These colored borders will appear when you go to print your spreadsheet. If you are simply looking to print your spreadsheet’s gridlines, you can read this article.

 

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Highlight the cells to which you want to add your borders.

select the cells to edit

 

 

Step 3: Click the Home tab at the top of the window.

click the home tab

 

 

Step 4: Click the Font Settings button at the bottom-right corner of the Font section of the navigational ribbon.

click the font settings button

 

 

Step 5: Click the Border button at the top of the window.

click the border tab

 

 

Step 6: Click the drop-down menu under Color, then select the color that you want to use for your borders.

click the color drop-down menu

 

 

Step 7: Click the buttons around the border preview at the right of the window to add your borders. Click the OK button at the bottom-right corner of the window to apply these border settings to your selected cells.

click the border buttons around the border preview

 

 

Do you need to add a document name, to similar information, to every page of your printed spreadsheet? Add a header in Excel 2013 for a simple way to accomplish this.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.