To change or undo these settings, repeat these steps. To turn off gridlines, see Show or hide gridlines in Word, PowerPoint, or Excel. If you want to change the measurement units in PowerPoint, see Change the ruler units from inches to centimeters. On the Layout or Page Layout tab, in the Arrange group, click Align, and then click Grid. In Excel, by default, the gridline is gray, but in some cases, you want to change this default color to other colorful color as screenshot shown, how could you do?
Have you ever opened an Excel spreadsheet and discovered that the gridlines were missing? Here are fourĀ possible reasons that gridlines are not visible in MS Excel. The gridlines may be turned off Click on the View tab, then check the box for Gridlines in the Show group. They are colored over If the background color for a cell is white instead of no fill, then it will appear that the gridlines are missing. Select the cells that are missing the gridlines, or hit Control + A to select the entire worksheet. Then, under the Home tab in the Font group change the color of the cells by clicking on the little arrow to the right of the can of spilling paint and choosing no fill.
The borders have beenĀ colored white Select the affected cells, or select everything with Control + A, then right click on the cells and choose Format Cells. Under the border tab, change the Color to Automatic. The gridlines have been colored white Click on the File tab. Then choose Options. Click on Advanced. Scroll down to the Display options for this Worksheet section, and change the Gridline color to Automatic.
![How to change gridlines color in excel How to change gridlines color in excel](/uploads/1/2/5/6/125626124/776105789.png)
Thanks to Kim Beaumont for the great tip!