How to Make Gridlines Darker in Excel 2016

The steps in this guide will show you how to make the gridlines darker in Excel 2016.

  1. Click the File tab at the top-left of the window.
  2. Select the Options button at the bottom of the left column.
  3. Choose the Advanced tab.
  4. Scroll down to the Display options for this worksheet section, then click the Gridline color button.
  5. Select a darker color.
  6. Click the OK button.

If you are having trouble viewing the gridlines on your screen or when you print your spreadsheet, then you may be looking for a way to make the gridlines darker in Excel 2016.

Luckily this is an option that you can adjust through the Excel Options menu in the application. Our tutorial below will show you how.

How to Use Darker Gridlines in Excel 2016

The steps in this article were performed in Microsoft Excel for Office 365, but will also work in other newer versions of Microsoft Excel, such as Excel 2016.

Step 1: Open your file in Microsoft Excel.

Step 2: Click the File tab at the top-left of the window.

click the File tab

Step 3: Click the Options button at the bottom of the column on the left side of the window.

click the Options button

Step 4: Select the Advanced tab at the left side of the Excel Options window.

select the Advanced tab

Step 5: Scroll down to the Display options for this worksheet section of the menu, then click the button to the right of Gridline color.

how to make gridlines darker in Excel 2016

Step 6: Choose a darker color from the color picker, then click the OK button at the bottom of the menu.

Find out how to print a blank spreadsheet in Excel if you need a blank grid so that you can write in it.

Another option that you have for making the gridlines darker doesn’t actually involve changing a setting for the gridlines. You can select all of the cells where you want to use a darker color, then click the arrow to the right the Borders button on the Home tab.

You can then select the All Borders option from this drop-down menu.

apply all borders to selected cells

Re-open that menu again, choose the Line color option at the bottom of the menu, then select the desired color.

change the border line color