How to change spreadsheet color lines in Excel

By default, the cell line colors in Excel have a rather fuzzy black color. If you work often for a long time, this color will be quite messy, or mistaken for the content. If so, you can change the color of the grid lines in the Excel table. You can change the default matte black color in the grid panel to your chosen colors. The following article will guide you how to change spreadsheet grid line colors in Excel.

1. How to format borders and background colors for Excel tables
2. 4 basic steps to color alternating lines in Microsoft Excel
3. Instructions on how to create diagonal lines in Excel box

Video tutorial to change the color of Excel worksheet

How to change the spreadsheet color line on Excel

Step 1:

At the Excel interface you click on the Office icon and then click on Excel Options .

How to change spreadsheet color lines in Excel Picture 1

Step 2:

In the next interface click on the Advanced section, then you look to the right of Display options for this worksheet . In the Gridline Color section select the Excel grid line color according to your will to color the grid line.

Then press the OK button below to save.

How to change spreadsheet color lines in Excel Picture 2

Step 3:

After selecting the color we will see a new cell line color for Excel as shown.

How to change spreadsheet color lines in Excel Picture 3

To create a display cell area for Excel, we can select the area and then right click, click on Format Cells .

How to change spreadsheet color lines in Excel Picture 4

Step 4:

In the Format Cells dialog box, click the Border tab .

How to change spreadsheet color lines in Excel Picture 5

Next to the user select the type of line in the Style section. Then go to the Presets section and then click Outline then go to Inside to select the box for the entire selection. Note that if the user wants to change color from the grid line color, in the Color section, click on the color you like. Or to match the grid lines.

How to change spreadsheet color lines in Excel Picture 6

As a result, we will get the table with the highlighted colors as shown.

How to change spreadsheet color lines in Excel Picture 7

Depending on the user, we can choose different colors to change for Excel spreadsheet. This will make the Excel table look more eye-catching and clear.

See more:

1. How to use underline styles in Excel
2. A guide to the full Excel 2016 (Part 12): Page formatting and spreadsheet printing
3. How to create a password protection for Excel sheets

I wish you all success!