- Select the sheets on which you want to change the gridline color.
When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets.
Note If sheet tabs have been color-coded, the sheet tab name will be underlined in a user-specified color when selected. If the sheet tab is displayed with a background color, the sheet has not been selected.
Cancel a selection of multiple sheets
To cancel a selection of multiple sheets in a workbook, click any unselected sheet.
If no unselected sheet is visible, right-click the tab of a selected sheet. Then click Ungroup Sheets on the shortcut menu.
- On the Tools menu, click Options, and then click the View tab.
- Under Window options, click the color you want in the Color box.
To use the default gridline color, click Automatic.