Microsoft Excel Logo

Microsoft Excel provides you with gridlines on each spreadsheet in a workbook by default. However, the gridlines might be too faint on your screen. If you’d like to make the gridlines darker in Excel, we’ll show you how.

There are two simple methods for making the gridlines bolder and easier to see. You can use a darker color than the default light gray or you can apply a grid border to the entire sheet. Let’s look at both options so you can pick the one that best fits your needs.

RELATED: How to Change the Color of the Gridlines in Excel

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

Advertisement

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.

RELATED: How to Create a Custom Border in Microsoft Excel

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.”

Advertisement

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. For more, take a look at how to print the gridlines in Excel.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »