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 QUIZ

How well do you know small business?

There are over 30 million small businesses in the U.S., and many of them are optimistic in their outlook. Are you familiar with the obstacles and opportunities they are facing? Test your small business acumen with this quiz sponsored by Chase Ink®.

SPONSORED REPORT

In focus: Payroll

Providing payroll services that comply with ever-changing regulations and meet evolving employee and employer demands is no easy task. Paychex's Tom Hammond discusses common payroll considerations for CPA firms.