How To Change The Gridlines Color In Excel 2007

The default color of the gridlines in MS Excel 2007 is light blue that truly matches with the color scheme of MS Office 2007 whose applications contain the Ribbon and the side areas in the same color. However, have you ever thought of changing the blue color of these gridlines? Well, you will be happy to know that you can do so. If you are a real geek, this is something that you will love to know, as geeks always like to change things according to what they fancy.

If you are working with Excel 2007 as a professional, you will know that it is not always the personal preference that will make you alter the color of gridlines. So, what else can make you do that? Well, we shall check that out now along with the steps to change the gridline color.

Problem: Need To Have Sheets Each With Different Gridline Color In the Same Workbook

Let us assume a scenario wherein you are working as a Sales Manager in a company. You have recently got a new project whose client has strict requirements for maintaining the vital files of which one is an Excel workbook. For this workbook that will store the details of each product to be delivered, the client has specified to maintain each sheet with a different gridline color.

This is based on the fact that the gridlines in each sheet must represent the default color of the corresponding product (deliverable) so that it becomes easy to identify which sheet speaks of which product. Although the sheets will be renamed, these names would be the dummy names that will change at the end. Therefore, you need to know the procedure of changing the color of the gridlines in each sheet of a workbook.

Solution: Change The Default Color Of The Gridlines

MS Excel 2007 allows you to modify the gridline color in each sheet of a workbook. It offers the standard color list from which you can select the color of your choice. However, you will have to perform this selection repeatedly for each sheet in the workbook. Moreover, you need to remember that this selection does not change the default gridline color, which means that if you create a new workbook, it will still have the standard blue gridlines.

Implement The Solution: Change The Advanced Setting For The Gridlines

The MS Office button in Excel 2007 allows you to change the gridline color in each sheet. Here are the steps to set a different color for the gridlines in Excel 2007.

1. Open MS Excel.

2. Click the Office button located at the extreme left corner. A drop-down menu is displayed.

3. Click the Excel Options button. The Excel Options dialog box is displayed.

4. On the left side, select the Advanced tab. The panel called Advanced options for working with Excel is displayed.

5. In the panel, scroll down to the Display options for this worksheet section.

6. Select the desired sheet whose gridline must have a different color from the Display options for this worksheet combo box.


7. Click the Gridline color drop-down list. A list of colors is displayed.

Also Read

Copy Excel Formatting The Easy Way With Format Painter 
How To Change The Default Font In Excel 2007 

8. Select the required color. The thick dash below the icon shows the selected color.

9. Repeat steps 6 to 8 for all those sheets whose gridline color has to be changed.
10. Click OK.



Dipaligandhi