Microsoft Excel 2010

Change Worksheet Gridline Colors to Fit Your Mood

SUMMARY: In Excel 2010, alter the standard gridlines so they appear in blue, green, or yellow.

In an attempt to make spreadsheets appear less dull, Microsoft Excel 2010 lets you change the color of gridlines. Tired of the traditional black? Perhaps gridlines in aqua, gold, or violet will cheer you up. You can even change colors on a worksheet by-worksheet basis, so your gridline colors can match your tab colors.

1. Select the "File" tab in the Ribbon.

2. The Microsoft Office Backstage View appears. Click the "Options" button.

(Or instead of steps 1 and 2, press Alt + T, then the letter O.)

3. The "Excel Options" dialog box appears. Click "Advanced" in the left pane.

4. In the right pane, scroll down to "Display options for this worksheet". Click the pull-down next to it to choose the worksheet to modify from the currently-open workbooks.

5. Next to "Gridline color", click the pull-down to choose your desired color or select "Automatic" for the default.

Changing the gridline color for a particular worksheet in Excel 2010

6. Click "OK" on the bottom-right of the dialog box to close it.

Return to the Microsoft Excel 2010 page.

Thanks For Sharing!



Newest Tips

Cell Phone
[MODIFIED] Six Battery Conservation Tips
Google Search Engine
What is My IP Address?
Mozilla Firefox - Misc
Missing the Title Bar? Menu Bar?
Windows 8
Bring Back the Mouse Pointer Drop Shadow

Follow/Contact Us!


About MalekTips and the Author

The MalekTips website was created in 1998 by of Envision Programming. The page's goal is to freely disperse computer-related tips, hints, and informative articles. Tips are organized to be easy to find, and are presented clearly, in easy-to-understand language.