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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.