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

A new line of business to consider

Technology assessments may open the door to new engagement opportunities for your firm. What is a technology assessment? How do you perform one? JofA Tech Q&A author J. Carlton Collins shows you in a detailed explanation.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.