Changing the Gridline Color in MS Excel 2010

As you can customize the Ribbon and the Quick Access Toolbar of excel Application, you can also customize the Gridlines of Excel Worksheet by changing its color. Follow these simple and easy steps to change the color of Gridlines in excel Worksheet.

1) Open the Excel Worksheet; then click on the “Office” button and then click on the “Excel Options”. See Figure 1 for details.

Figure 1

2) Now in the “Excel Options” window that appears on the screen, click on the ‘Advanced’ category and then scroll a bit downwards to find the Sub- category “Display Options for This worksheet”. In this Sub-category, click on the ‘Gridline Color icon’ and choose the color that you want to apply to the Gridlines. See Figure 2 for details.

Figure 2

3) Now you can observe that the color of your Gridlines has changed as per the specifications. See figure 3 for details.

Figure 3

So, this is how you can change the color of Gridlines in MS Excel 2010 Apllication.

Read article changing Gridline color in MS excel 2007

Read Other Applications