How to Darken Grid Lines in Microsoft Excel


➥ Go to the beginning of the Free Online Excel Course

By default, Microsoft Excel provides lines from Grid to each spreadsheet and these can be darken to highlight the sheet in question. Precisely this is something that many people come to complain about, that the grid lines can become too dim on the screen.

There are two methods that are too easy to carry out to be able to customize the grid lines in Excel and darken them. We can even use different colors depending on the work we are doing.

Darken grid lines from Settings in Excel

The first thing we will do is open a workbook in Excel, we will have to select the File tab and choose “Options”.

Select document.

Here we are going to choose “Advanced” in the left sidebar of this new window. On the right side, we scroll down to Show options for this worksheet.

We can see a drop-down box at the top of this section. From here, if we prefer we can apply the change to a different sheet or we can choose the one we are using.

Choose colour.

At the bottom, we will click on the four drop-down next to grid color and we are going to choose an option. We can choose a basic black or make the grid lines result with any other color.

To apply the changes, the only thing left to do is click “OK”.

So we can darken Excel grid lines

In case you want to reverse the change and use the color that comes by default, we simply return to the same section and we will have to choose “Options”, “Automatic” in the color drop-down box.

Apply border to sheet


If we need the grid lines to be bold, the best method is to apply a border to the entire sheet. For this we are going to select the sheet by clicking on the triangle that is in the upper left corner between column A and row 1, it is pointing down.

Mark borders Excel.

Next, we will have to go to the “Home” tab and click on the All borders drop-down arrow. From here, we will have various ways to darken the grid lines.

If we choose “All borders” we can change the grid lines to thin black lines. When we select “Line color”, we choose a color and then click on “All borders”. “Line style”, we choose one of the thicker styles and we will click on “All edges”.

We can also use a combination of color and line style if we want a custom border. We’ll just have to make sure to select these options first and then choose “All Borders”.

If we apply a border and we don’t like the result, all we have to do to reverse it is click on “Undo” and the grid lines will remain as default.

Share it with your friends!

Next Post

"For a career without obstacles": the manifesto of the Ufec for the 8M

Laia Palau is one of the most outstanding women athletes at the state level in recent years (3-8-2022) The Ufec has launched a manifesto in vindication of the figure of women in society, in general, and in the world of sports, specifically. “For a career without obstacles” is the slogan […]
"For a career without obstacles": the manifesto of the Ufec for the 8M