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

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

Pronoun practice to help polish your prose

Using pronouns correctly in writing and speech can help you make a good impression. Try our 10-question quiz.