Customize Excels Gridline Color

BY STANLEY ZAROWIN

Q. I heard the gridlines of a spreadsheet don’t have to be black—they can be any color. I’d like to color some of my gridlines so I can make the results of each month, say, a different color for easy identification. However, I’ve tried to do that, but I’ve been unsuccessful.

A. Yes, you can change gridline colors. You can make the lines of each worksheet a different color, but you can’t have different colors within a worksheet. However, if you want easier identification inside a worksheet, you can easily change the color of the data in cells ( Format , Font and Color ).

To change gridline color, click on Tools , Options and the View tab. Under Window options place a check in the Gridlines box and click on the down arrow next to Gridlines color for the selection of colors. After you make a selection, click on OK .

Do the same for each workbook and you can have a different color for each.

In turquoise

…and in red.

SPONSORED REPORT

2018 financial reporting survey: Challenges and trends

Learn the top reporting challenges that emerged in a survey of more than 800 finance, accounting, and compliance professionals across the world, and compare them with your organization's obstacles.

PODCAST

How the skill set for today’s CFO is changing

Scott Simmons, a search expert for large-company CFOs, gives advice for the next generation of finance leaders and more, including which universities are regularly producing future CEOs and CFOs.