Changing Gridline Color

Summary: The gridlines used in a workbook are normally light black. You can modify the gridline color by following the steps in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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:

Choose Options from the Tools menu. You will see the Options dialog box.
Click on the View tab. (Click here to see a related figure.)
Use the Color drop-down palette to select a color for your gridlines.
Make sure the Gridlines check box is selected.
Click on OK.

You can specify different gridline colors for each worksheet in a workbook.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2736) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.

Check out ExcelTips Premium today!