See all How-To Articles

Change Gridline / Cell Border Color in Excel & Google Sheets

In this article, you will learn how to change the cell border color in Excel and Google Sheets.

 

change border line color 6

 

Change Gridline Color

1. To change the gridline color, in the Ribbon, click on File > Options.

 

change border line color 1

 

2. The Excel Options window will appear. In the menu, (1) click on Advanced, then scroll to the Display options for this worksheet. Under this section, (2) click on the icon next to the Gridline color and then (3) choose the wanted color for the gridline. When done, (4) click on the OK button.

 

change border line color 3

 

Now the gridline color is changed to blue, as you can see below.

 

change border line color 4

 

For more options related to gridline display, see What Are Gridlines?

Change Cell Border Color – Format Cells

Say you have a list of the data range (in this example, B2:D5) with a border around it. To change the border color (in this example, from black to orange), follow these steps:

1. First, (1) select the cells whose border colors you want to change, then in the Ribbon (2) go to Home, in the Font group (3) click on the Borders button and from the drop-down menu (4) choose More Borders.

 

change border line color 12

 

2. The Format Cells window will appear. To choose the color of the border, (1) click on the arrow next to the Color button, (2) select the color, and then in the preview diagram (3) click on the parts of the border whose color you want to change. When done, (4) click the OK button.

 

change border line color 8

 

As a result, the border color is changed.

 

change border line color 15

 

Change Cell Border Color – Border Command

1. In the Ribbon (1) go to Home and in the Font group, click on (2) Borders button. In the drop-down menu, (3) click on Line Color, then (4) select the wanted color for the border.

 

change border line color 13

 

2. The cursor will change to a pencil. With it, just click on the part of the border whose color you want to change.

 

change border line color 9

 

As a result of the steps above, the color of the border is changed.

 

change border line color 14

 

NOTE: You can also use VBA code to set cell border color.

Change Cell Border Color in Google Sheets

1. To change the color of the border in Google Sheets, first select the cells with borders whose color you want to change.

2. Then in the Toolbar, click on the Borders button.

3. In the menu, click on the Change Color button.

4. Then select the color.

5. To finish, click on the border style for the cell whose color you are changing.

 

change border line color 17

 

As a result of this, the color of the border is changed.

 

change border line color 19

 

Unfortunately, there is no option to change the default color of the gridlines in Google Sheets.