Formatting Issues

Why Excel Gridlines Look Dotted or Solid and How to Change Their Appearance

Chanuka GeekiyanageChanuka Geekiyanage Nov 20, 2026 869 views

Question details

Understand why gridlines look dotted in one Excel workbook and solid in another, and find ways to change their appearance.

Why Excel Gridlines Look Dotted or Solid
Product
Microsoft Excel
Device & OS
not provided
Scenario
Two workbooks have matching border formatting but display worksheet gridlines differently.
Observed behavior
Gridlines appear dotted in one workbook and solid in the other, even though the cell borders use the same styles and colors.
Before you start

Open both workbooks and select the worksheets you want to compare. Check that gridlines are enabled and note the zoom level in each workbook.

Solution 1Recommended

Check Excel View Settings and Reset the Gridline Color

Use this approach to troubleshoot differences in how worksheet gridlines appear on screen.

Excel does not offer a direct setting to switch gridlines between dotted and solid. Their appearance can vary with gridline color, zoom, display scaling, and view settings.

Cell borders are separate from gridlines, so matching border formatting does not guarantee matching gridline appearance.

1
Check gridline visibility

In each workbook, select the worksheet and open the View tab. Make sure Gridlines is checked in the Show group.

2
Compare zoom levels

Use the zoom control at the bottom of each workbook window or open View > Zoom. Set both sheets to the same zoom level and compare their gridlines.

3
Reset the gridline color

In Excel for Windows, go to File > Options > Advanced. Under Display options for this worksheet, select the affected sheet and set Gridline color to Automatic, then select OK.

4
Check display scaling

If the gridlines still look different, check your device's display scaling settings and compare the workbooks at the same zoom level.

Check Excel View Settings and Reset the Gridline Color
Results can vary: Changing the gridline color and then returning it to Automatic resolved the appearance in one reported case, but it may not work in every workbook.
Work with spreadsheet gridlines

Create Consistent Solid Cell Lines in WPS Spreadsheet

Use solid cell borders in WPS Spreadsheet when you need a consistent line style instead of relying on the display of gridlines.

  1. 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Select the range: Select the cells where you want consistent solid lines.
  3. 3. Choose border formatting: Right-click the selection, choose Format Cells, and open the Border tab. Select a solid line style and color.
  4. 4. Apply and save: Choose the outline and inside borders you need, select OK, and use File > Save As to save the workbook.
Apply a solid border style to a selected cell rangeOpen and save Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formatting controlsWork with spreadsheets for free
QA img-9

Frequently Asked Questions

Can I change Excel gridlines from dotted to solid directly?

No. Excel does not provide a direct dotted-or-solid gridline setting. You can check View > Gridlines, adjust zoom, reset the gridline color, or apply solid cell borders.

Where do I change the gridline color in Excel?

In Excel for Windows, go to File > Options > Advanced and find Display options for this worksheet. Select the worksheet and choose a color from Gridline color, or select Automatic to reset it.

Why do matching cell borders not make the gridlines look the same?

Borders are cell formatting, while gridlines are worksheet display guides. Gridline appearance can vary with color, zoom, view settings, and display scaling independently of border formatting.

Will gridlines or cell borders print?

Cell borders generally print as formatting. To print gridlines in Excel, open Page Layout and check Print under Gridlines in Sheet Options.