Microsoft Excel: Pick a new color for your gridlines

By J. Carlton Collins, CPA

Q. Is it possible to change the color of the gridlines in Excel?

A. You can change the color of the default gridlines in Excel from the File tab, by selecting Options, Advanced. In the Display options for this worksheet section, click the Gridline color drop-down box and select a color from the color palette, as shown below. (Make sure the Show gridlines check box is selected.)

Some CPAs like to change gridlines to something lighter, such as light blue, so they don't clutter the screen as much. Personally, I prefer no gridlines. Instead, I insert borders where I want gridlines to appear, such as in tables where my worksheet assumptions are entered. Also note that your gridline color can be different for each worksheet in your Excel workbook.

techqa-8

About the author

J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

SPONSORED REPORT

Get your clients ready for tax season

These year-end tax planning strategies address recent tax law changes enacted to help taxpayers deal with the pandemic, such as tax credits for sick leave and family leave and new rules for retirement plan distributions, as well as techniques for putting your clients in the best possible tax position.

RESOURCES

Keeping you informed and prepared amid the coronavirus crisis

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.