"Offering free computer help, hints, and tips to the Internet populace." Now with over 3,820 tips!

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.

Print this tip

Get the Newsletter

blog comments powered by Disqus

Thanks For Sharing!

Newest Tips:

Windows 8
Make Two More Time Zones a Mouse Hover Away
Sites to Browse - Humor - Pranks
When Online Reviews get Ridiculous
Windows 8
Make it Easier to Differentiate Explorer Windows by Showing Full Paths
Google Chrome
Easily Share Content on Facebook, Pinterest, Twitter, More

Follow Us!

About MalekTips and the Author

The MalekTips website was created in 1998 by Andrew Malek 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. MalekTips also provides information and links to public-domain, open source, freeware, shareware, and commercial software available for download.