A Better Way To Color Spreadsheet Gridlines

BY STANLEY ZAROWIN

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 .

 

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.