Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Changing Gridline Color.
The gridlines help you track information on the screen easier and to locate cells quickly. Normally the gridlines are shown in black, but you may want to make them some other stylish color. If you want to change the gridline color, follow these steps:
Figure 1. The Advanced options of the Excel Options dialog box.
You can specify different gridline colors for each worksheet in a workbook.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8728) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Changing Gridline Color.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
When keeping track of dates, internally, Excel uses special date serial numbers that are based upon a specific day in the ...
Discover MoreA little green triangle in the corner of a cell means that Excel thinks there is an error with the cell contents. If ...
Discover MoreEnter a value into a cell and "poof!" it is automatically divided by 100. What's going on, and how can you fix it so that ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-05-28 16:54:48
Peter Atherton
With regards to John Mann's post: it works on grouped sheets in 2016
2020-05-27 14:01:15
Allen
It really is there Katherine -- Click File and then, at the left side of the screen look all the way near the bottom and you'll see "Options." Click that.
-Allen
2020-05-27 13:21:31
Katherine
There is no "options" in the back menu of excel in office 365 so this doesn't work for 365.
2019-10-19 18:28:06
John Mann
I hadn't paid much attention to this option - so much so that I had forgoten it exists. I've just been experimenting a bit with this option and note that it doesn't work on grouped worksheets (at least not in my copy of Excel 2010).
It does occur to me that it would be usefull to use the same colour for the grid and the tabs. This could help with keeping track of which sheet we are working on when we have several sheets with similar (or identical) layout. I have often missed the thin but obvious line across the screen matching the tab colour used by Lotus 1-2-3. While it would not be a terible hardship to manually make that combination, it would be nice to automate it.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments