The steps in this guide will show you how to make the gridlines darker in Excel 2016.
- Click the File tab at the top-left of the window.
- Select the Options button at the bottom of the left column.
- Choose the Advanced tab.
- Scroll down to the Display options for this worksheet section, then click the Gridline color button.
- Select a darker color.
- 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.
Step 3: Click the Options button at the bottom of the column on the left side of the window.
Step 4: Select the Advanced tab at the left side of the Excel Options window.
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.
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.
Re-open that menu again, choose the Line color option at the bottom of the menu, then select the desired color.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.