"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:

Google Chrome
[MODIFIED] Add Button to Scroll to Top of Long Web Pages
Google Gmail
Show Maps Automatically in Emails Instead of Copying and Pasting
Windows 8
Shrink the Taskbar Buttons
Sites to Browse - DVDs - Movies
[MODIFIED] Learn to Talk like Yoda

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.