Cart 0

How to change the gridlines color in Excel

Posted by Roger Hyttinen on

Gridlines button menu

What many people don't realize, is that we are not stuck with the light gray color of the gridlines in Excel and in fact, we can change them to any color we like. So you if gridlines color in your worksheet is not to your liking, change it to a color more suitable to your tastes.

To Change the Worksheet Gridlines Color

  1. Click the File tab on the Ribbon.
  2. Click Options
  3. Click Advanced in the left pane.
  4. Scroll down until you see Display options for this worksheet.

    Worksheet Display Options

  5. Click the Gridlines Color drop-down arrow and choose the color you want from the gallery.
    Gridlines color palette
  6. Click OK

Tip: You can also hide gridlines from this area by unchecking the Show Gridlines box.

Looking for more Excel tips? Check out our new book Excel 2016:Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks

Share this post

← Older Post Newer Post →

Leave a comment

Please note, comments must be approved before they are published.