The default gridlines in Excel are a very light gray and can sometimes be hard to see. Excel allows users to adjust the color and thickness of the gridlines to suit their needs. Making the gridlines darker can help make them more visible, making it easier to differentiate between cells. Whatever your preference there are options to customize your gridlines. Get your copy of the example workbook used in this post and follow along!
Make Gridlines Darker with Excel Options
When you need to change any sort of setting, the first place you should look is the Excel Options menu. This is where a lot of customization can be set in Excel. You’ll be able to make the gridlines darker by changing the gridline color to black or a similar darker color depending on your preference. Follow these steps to change the gridlines to a darker color. 📝 Note: You will need to update this setting for each sheet in your workbook. Your gridlines will now appear darker with your chosen color!
Make Gridlines Darker with Home Tab
Do you want to make the gridlines in your sheet thicker and darker? Then you will need to add borders to all the cells in your sheet. The Excel Options menu does not allow you to adjust the gridline thickness, but using the cell border format will allow you to adjust both the color and thickness. Here’s how you can change the color and size of the gridlines. 💡 Tip: You can also use the Ctrl + A keyboard shortcut to select the entire sheet. You can also choose the More Borders option to open the Cell Format dialog box. This is where you will be able to adjust the line thickness and color. You can also open Format Cells menu by using the Ctrl + 1 keyboard shortcut. Choose a new line Style and Color. Click on the Outline and Inside button to apply these new settings to the cells and then press the OK button. All your cells in the sheet will get the updated cell borders!
Make Gridlines Darker in All Sheets with VBA
When you need to automate a task in the desktop version of Excel, then VBA is the way to get it done. The Excel Options menu makes changing the gridline color for each sheet a tedious task. You can automate this with VBA so that you can set the gridline color for all your sheets by running a macro. Go to the Developer tab and select the Visual Basic option from the ribbon or use the Alt + F11 keyboard shortcut. This will open the visual basic editor and you will be able to add any VBA code here that you might want to run. 💡 Tip: Check out this post to see how you can add the Developer to your Excel ribbon. Go to the Insert menu and select the Module option to create a new module for your VBA code. Paste the above VBA code into your visual basic editor module. This VBA code will loop through each sheet in your workbook and set the gridline color based on the RGB code supplied. In this example RGB(0, 0, 0) will set the gridline color to black. 📝 Note: The Excel Options gridline color selection is limited, but with the VBA code, you will be able to set any color using its RGB description. After you run the VBA code, all your sheets will have a darker grlidline color!
Make Gridlines Darker in All Sheets with Office Scripts
If you are using Excel online, then there is no possibility of automating your tasks with VBA. But you might be able to use Office Scripts if you are using Excel online with a Microsoft 365 business plan. This is a new scripting language currently only available for the web version of Excel. Open your Excel workbook in the browser and go to the Automate tab and select the New Script option. This will open the Code Editor and you can add your code inside. Paste the above code into the editor. This code will loop through each sheet and change the border style, color, and line weight for the entire sheet. You can customize these formats to your liking.
Change “FF0000” to any hex code value for different color options.Change BorderLineStyle.continuous to other line styles.Change BorderWeight.thick to other line weights.
Press the Run button in the Code Editor and the script will run and change the gridline format accordingly.
Conclusions
Making the gridlines darker is a great way to distinguish between each cell more clearly. There are several ways to accomplish the task of changing the gridline colors in your Excel sheets. You will find this setting in the Excel Options menu, but unfortunately, there is no way to change the thickness in these settings. If you need to change both the color and thickness, then you can use the cell format options. If you need to update the gridline color across many sheets in your workbook, you can use VBA on the desktop or Office Scripts online to automate this task. Do you ever change the gridline color in Excel? Let me know in the comments below!
