Why Excel Gridlines Look Dotted or Solid and How to Change Their Appearance
Question details
Understand why gridlines look dotted in one Excel workbook and solid in another, and find ways to change their appearance.

- 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.
Open both workbooks and select the worksheets you want to compare. Check that gridlines are enabled and note the zoom level in each workbook.
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.
In each workbook, select the worksheet and open the View tab. Make sure Gridlines is checked in the Show group.
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.
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.
If the gridlines still look different, check your device's display scaling settings and compare the workbooks at the same zoom level.

Apply Solid Cell Borders for a Consistent Appearance
Use borders when you need explicit solid lines rather than relying on how Excel renders 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. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Select the range: Select the cells where you want consistent solid lines.
- 3. Choose border formatting: Right-click the selection, choose Format Cells, and open the Border tab. Select a solid line style and color.
- 4. Apply and save: Choose the outline and inside borders you need, select OK, and use File > Save As to save the workbook.

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.




