How do I modify the gridline color in an Excel table

Show all hidden by default, in worksheets worksheet: The primary document that you use to store and process data in Excel. Also known as spreadsheets. Worksheets are made up of cells that arrange rows or columns. The worksheet is always stored in the workbook. Displays gridlines using the color assigned to auto. However, you can display gridlines in a different color on the selected worksheet.

Select the worksheet for which you want to change the gridline color.

How to select a worksheet

Select action

One sheet Click the sheet's label.

If you don't see the label you want, click the Label Scrolling button to display the label you want, and then click the label.

Two or more adjacent worksheets Click the tab of the first worksheet, and then hold down Shift while you click the label of the last sheet you want to select.

Two or more nonadjacent worksheets click the tab for the first worksheet, and then press and hold CTRL while you click the tabs of the other worksheets you want to select.

All worksheets in a workbook right-click the tab of a worksheet, and then click the shortcut menu shortcut menu: A menu that shows a list of commands related to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10. , select all sheets.

Tip When you select more than one worksheet, the word [workgroup] appears in the title bar at the top of the worksheet. To deselect more than one worksheet in a workbook, click any unselected worksheet. If you don't see a worksheet that is not selected, right-click the tab for the selected worksheet, and then click Ungroup Sheet on the shortcut menu.

In the advanced category, under Display options for this worksheet, make sure that the Show gridlines check box is selected.

In the Gridline color box, click the color that you want.

Tip To return gridlines to the default color, click Automatic.

Method Two:

Excel tab gridlines are black by default, so if you want to change other colors, how do you set it? After reading the following tutorial, you will set freely!

Operation Steps:

1, open Excel2007, click on the upper left corner of the MS Office Button, select "Excel Options."

2, in the "Excel Options" → "advanced" found in the "Display options for this worksheet" below the "grid line Color", choose your favorite color, OK.

3, replace the primary colors of the form.