A Better Way To Color Spreadsheet Gridlines


In the June 2004 JofA (page 80), a reader asked how to change the colors of her spreadsheet gridlines so she could easily identify the results of different months. I responded that while gridline color can be changed ( Tools , Options , View , Gridline color ), any change affects the entire worksheet—not just parts of it.

However, I failed to suggest the obvious and most simple solution for not only changing all the gridlines in a worksheet to one color, but also setting them to many different colors. Thankfully, one alert reader called it to my attention. Michael A. Berson, CPA, CFO of Sidney Fetner Associates, New York, says you can produce variously colored gridlines (see screenshot below) within one worksheet by using the Format Cells command.

To do that, highlight the cell or cells to which you wish to add color. Right-click in that highlighted space, left-click on Format Cells and click on the Border tab. Select your color from the drop-down menu and then either choose the type of border from the array of choices or click on any of the corner symbols or the word Text in the center box. When you’re satisfied with the color and arrangement, click on OK .



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.


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.