How to make gridlines darker in Excel

You can watch a video tutorial here.

Excel is a powerful spreadsheet application in which the layout is in the form of a grid of cells created by rows and columns. By default, the color of the grid is an unobtrusive gray so that it does not overpower the values that you type into the cell. There may be a situation when you want to make the gridlines darker. For example, you may be using Excel to create graph paper and need the gridlines to be more visible when the sheet is printed. You can either change the color of the gridlines or create a darker border around each of the cells in the grid. 

Option 1 – Change the color of the grid

Step 1 – Open the Excel Options window

  • Go to File > Options

Step 2 – Change the color of the grid

  • Select the Advanced section
  • Go to Display options for this worksheet
  • Expand the dropdown list for the Gridline color
  • Choose Black
  • Click OK

Step 3 – Check the result

  • The color of the gridlines is changed to black which is darker than the gray

Option 2 – Create darker cell borders

Step 1 – Select the sheet

  • Select the entire sheet by clicking in the top left corner

Step 2 – Open the Format Cells window

  • Go to Home > Font > More Borders


Right-click and select Format Cells  from the context menu


Go to Home > Number  and click on the arrow to expand the menu


Go to Home > Cells > Format > Format Cells


Press Ctrl+1

Step 3 – Create the borders

  • Go to the Border tab
  • Select a bold line style
  • Click on the Outline and Inside preset options
  • Check the preview to see that the borders are correct
  • Click OK

Step 4 – Check the result

  • The gridlines are now bold