How to Change Border Color in Excel (3 Suitable Ways)

In Microsoft Excel cells are distinguished by cell borders. But sometimes border colors are not visible. In that case, we need to change the border color. In this article, we will discuss how to change the border color in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Methods to Change Border Color in Excel

Here, we will discuss 3 simple methods to change border color in Excel. We have taken a sample Excel sheet, where the border of the cells is black.

We will show how to change the color of the cells in the below section.


1.  Utilize Format Cells Option to Change Border Color

In this method, we will use the keyboard shortcut to change the border color of desired cells.

📌 Steps:

  • First, place the cursor on Cell B4.
  • Select Range B4:D9 using the down and right arrow buttons.
  • Then, press Ctrl+1.

  • Now, the Format Cells window appears.
  • Go to the Border tab.
  • We get the Color section here.
  • Click on the down arrow of the Color section.
  • Now, choose your desired color from the list.

Utilize Format Cells Option to Change Border Color

As we want to color all the borders of the cells, we need to change the color of both the outside and inside of the cells.

  • Choose Outline and Inside from the Presets section.
  • Finally, press the OK button.

Utilize Format Cells Option to Change Border Color

  • Look at the worksheet now.

We can see the border has been changed into red from black.

We can also avail of the Format Cells option from the Context Menu. Just select the required cells and press the right button on the mouse.

Utilize Format Cells Option to Change Border Color

After that, follow the steps of the mentioned above section.

Read More: How to Add Cell Borders Inside and Outside in Excel (5 Methods)


2. Change Border Line Color from Draw Borders Drop-Down

In this section, we will discuss a process based on the ribbon option to change the color of the border. Here, we need to choose the cell borders each time to change the color.

📌 Steps:

  • Click on the down arrow of the All Borders section from the Home tab.
  • A list of options will appear here.
  • Choose Line Color from there.
  • Now, a list will appear with different color options.
  • We choose our desired color.

Change Border Color from Ribbon Shortcut

  • We can see a drawing pencil appears.

We will draw the cell borders with chosen color using a pencil. Also, some dots are showing. Those dots are the edge of each cell.

  • Now, select a border of any cell.

Change Border Color from Ribbon Shortcut

We can see the border color has changed.

  • Similarly, choose all the required cell borders to change the color.

In this method, we can change the border color of any cell without previous selection.

Read More: How to Add or Remove Cell Borders in Excel


3. Change Border Color of Entire Sheet from Advanced Display Options

In the previous methods, we changed the border color of selected or a certain number of cells. But now, we will change the border color of the entire sheet.

📌 Steps:

  • Click on the File tab.

  • Now, the list will appear. Choose the Options from there.

  • The Excel Options window will appear.
  • Choose the Advanced option from the left side.
  • Find out the Display options for this worksheet section from the right side.
  • Now, check the Show gridlines option.
  • Then, click on the down arrow of the Gridline color section.
  • A list of colors will appear at the same time.
  • We choose our desired color.

Change Border Color of Entire Sheet From Excel Options

  • Finally, press OK.

We can see that the entire border of all cells of the entire sheet has changed.

Read More: [Fixed!] Table Border Not Showing in Print Preview (2 Solutions)


Conclusion

In this article, we described how to change border color in Excel. We showed two situations. One is for certain cells and another one is for an entire sheet. I hope this will satisfy your needs. Please look at our website Exceldemy.com and give your suggestions in the comment box.


Related Articles

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo