How to Change the Color of Excel Gridlines

Gridlines can help make your Excel spreadsheet easier to read. While the default color of Excel gridlines is black, you can change the gridline color of any worksheet by following these simple steps.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Computer with Microsoft Windows and Excel

1. Open a new or existing Excel worksheet.
2. If you do not see gridlines on the worksheet, click “Tools” on the Excel toolbar, and then click “Options."
3. Click the “View” tab, and under “Window Options," select the “Gridlines” check box. This will allow the gridlines to appear on the worksheet.
4. Still on the “View” tab, under “Window Options," select your desired color in the “Gridlines Color” menu.
5. Click “OK”. This will only affect your current worksheet. To change all worksheets in a workbook, hold down the “Ctrl” key, click on each tab and then follow the steps above.

Tips & Warnings

• If you would like your gridlines to show on your printed worksheets, go to “Page Setup” from the “File” menu. Click on the “Sheets” tab. Under “Print,” click “Gridlines” and then click “OK."

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.