Changing Gridline Color

Summary: Gridlines are very helpful in seeing where cells are located on the screen. You are not limited to black gridlines; here's how to change them to a color of your choosing. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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 if you are using Excel 2007:

Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
At the left of the dialog box click Advanced.
Scroll through the options until you see the Show Gridlines check box; select it.
Click the Gridline Color control and choose a color you want to use for the gridlines.
Make sure the Show Gridlines check box is selected.
Click on OK.

If you are using an older version of Excel, follow these steps instead:

Choose Options from the Tools menu. You will see the Options dialog box.
Click on the View tab.
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 | 2007

Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.

Check out ExcelTips: Serioius Sorting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Changing Gridline Color