How to change border color in Excel
October 14, 2022
By default, Microsoft Excel borders are grey in color. If you add a border colour, it will be black but sometime you may need to change the black color because it may not fit your content. How to change border color in Excel? Any idea? This article will introduce some tricky ways to change the border color. let’s begin.
Read More: How to add currency symbol in Excel
How to change border color in Excel?
There are different ways to change the border color in MS Excel. I will guide you and share five different tricky methods to change border color in Microsoft Excel. I have prepared an example excel sheet for the tutorial. Here it is.
We will use the above excel data to show you how to change the border color in Excel.
Use the Format Cells Option to change the Border color
- Select the range of cells that you want to change the border color. Right-click and select the Format cells option.
- Format cells window will appear. Select the Border tab.
- Choose the style of the border. Choose from the sample given.
- Select the color of your border you like.
- Set border for outline and also inside. A preview will be shown.
- Press OK to complete the task.
Here is what you have done.
Use the Border drop-down from the ribbon menu
- Select the range of cells you want to change the border color.
- Go to the Home tab Font group, and click the All border button to get the drop-down menu.
- From the dropdown menu select Line Color and choose your desired color.
- Your mouse cursor will be changed to a drawing pencil.
- With the help of that drawing pencil and mouse, you can change the border color of all desired cells.
Using Advanced Option
- Go to the File tab, and click Options. Excel Options will appear in front of you.
- Go to the Advanced Option, and find Display options for this worksheet. Select gridline and gridline color.
- Click OK to complete the task.
- We can see the entire worksheet gridline color has been changed.
Keyboard shortcut method
This is the most smart way to change the border color. You can remember it by AltHBI method.
- Press the Alt key of your keyboard to open the Home tab.
- Press the H key of your keyboard to open the Border menu.
- Press the I key of your keyboard to open the Line Color menu.
- Now select your desired color to be changed.
- Your mouse cursor will be changed to a drawing pencil.
- With the help of that drawing pencil and mouse, you can change the border color of all desired cells.
Set a Custom Table Style
- Select the range of cells in your table.
- Go to the Home tab, and click Format as Table under the Styles group.
- Select the design you like most.
- Check your table is already designed as per the selection.
Why should you change border color in Excel?
There are many more reasons to change the border color of your Excel worksheet. Did you think about the reason behind it before? I can share some reasons to think more about it.
- A change of border color makes your table more attractive to the viewer.
- Border color increases the importance of the table.
- A border color differentiates each cell from another.
- It helps to keep the attention of the viewer continously.
Dear Excel learner, you came here to know How to change border color in Excel, right? I hope, you already did it. If you feel that this page was helpful to you please make comment in the comment box to let other people know it. if you have any more queries comment box is open for you also. I will try my best to reply to your question. Thank You.
0 Comments