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.

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.