Pages

Friday, July 17, 2015

How to Change the Color of the Gridlines in Excel


00_lead_image_change_gridlines_color
You may not have thought about the color of the gridlines in Excel before, but if you’re bored with the default gray color or you want to use a color that’s easier on your eyes, you can change the color of the gridlines.
To select a different color for the gridlines on a worksheet in the current workbook, click the “File” tab.
01_clicking_file_tab
On the backstage screen, click “Options” in the list of items on the left.
02_clicking_options
On the “Excel Options” dialog box, click “Advanced” in the list of items on the left.
03_clicking_advanced
In the “Display options for this worksheet” section, click the button next to “Gridline color” and select a color from the palette that displays. Make sure the “Show gridlines” check box is selected.
NOTE: The gridline color can be different for each worksheet in the current workbook. The currently selected worksheet is the default choice in the drop-down list to the right of the section title. If you want to change the gridline color for a different worksheet, select that worksheet from the drop-down list.
04_selecting_gridline_color
The gridlines on your worksheet now display in the chosen color.
05_gridlines_in_pink
To return to the original, default gray color for the gridlines, go back into the options and select “Automatic” on the “Gridline color” palette.

No comments:

Post a Comment