Buzz
Have you known how to change gridline color in Excel yet? Follow Mytour's article below to know how to change the default gridline color in Excel spreadsheet to your favorite color with simple steps below, let's follow to know this way.
How to change the default gridline color in Excel
1. For Excel 2003
Step 1: Open the Excel file and select Tools and click Options
Step 2: The Options dialog box appears
+ (1) Select Tab View
+ (2) Select the color to change in the Gridline Color section
+ (3) Click OK
After changing, the gridlines will have the color as shown below
2. For Excel 2007
Step 1: Select (1) Office Button–>(2) Excel Options
Step 2: The Excel Options dialog box appears
- Choose Tab Advanced. In the Gridlines color: section, select the color you want to display for the gridlines.
- Press OK to finish.
- After changing, the gridlines will be as shown below
3. For Excel 2010
Step 1: On the Menu bar, select File and click Options
Step 2: The Excel Options dialog box appears
- Choose Tab Advanced. In the Gridlines color: section, select the color you want to display for the gridlines.
- Press OK to finish.
- After performing, the gridlines will change color as shown below
You do the same as Excel 2010 for Excel 2013
We have guided you on how to change the default gridline color in Excel spreadsheet, hoping that with the above instructions will help solve any confusion in getting acquainted with Excel. You can refer to Excel tips and tricks for more efficient use and operations on spreadsheets.
Another interesting trick in Excel is to alternate row or column colors, suitable for presenting data tables according to user preferences. If you don't understand it yet, you can review how to alternate colors in Excel here.
