Make Gridlines Darker in Microsoft Excel - - Windows Tips and Tricks with Geek

Wednesday, February 16, 2022

Make Gridlines Darker in Microsoft Excel

 Microsoft Excel Logo

Use a Darker Gridline Color in Settings

Open a workbook in Excel, select the File tab, and pick “Options.”

Choose File, Options

Choose “Advanced” on the left side of the pop-up window. On the right, scroll down to Display Options for This Worksheet.

You’ll see a drop-down box in the section heading that displays your currently selected sheet. So if you prefer to apply the change to a different sheet, you can select that one instead.

Select a different sheet box

At the bottom of the section, click the drop-down box next to Gridline Color and choose an option. You can pick a basic black or make the gridlines pop with a bright color.

Gridline color options

Click “OK” to apply the change.

Gridlines in various colors

To revert the change and use the default gridline color, return to the same area in the Options and pick “Automatic” in the color drop-down box.

Apply a Border to the Sheet

If you want bold gridlines in addition to darker ones, the best method is applying a border to the entire sheet. This allows you to choose a basic or custom border.

Select the sheet by clicking the triangle on the upper left corner between column A and row 1.

Entire sheet selected in Excel

Go to the Home tab and click the All Borders drop-down arrow. From here, you have a few ways to darken the gridlines.

  • Select “All Borders” to change the gridlines to black, thin lines.
  • Select “Line Color,” pick a color, and then click “All Borders.”
  • Select “Line Style,” pick one of the thicker styles, and then click “All Borders.”

Border options in Excel

You can also use a combination of color and line style if you want a custom border. Just be sure to select those options first and then choose “All Borders.”

If you apply a border and aren’t happy with it, simply click “Undo” immediately to revert to the default gridlines.

Making the gridlines in your Excel sheet easier to see is simple to do and you have flexible options.

No comments:

Post a Comment