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.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
When you make changes in a worksheet, Excel automatically recalculates everything that may be affected by that change. If ...
Discover MoreExcel can helpfully display some statistical information in the program's Status Bar. If you cannot see all 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 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.
Comments