How to Fix and Restore the Double-Line Border in Excel
Question details
The user needs to fix the Excel double-line border style, which is appearing incorrectly as a thick gray line in the border menu.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Applying cell borders across multiple monitors with different display scaling resolutions.
- Observed behavior
- The double-line border style looks like a single thick gray line in the Excel menu and may render incorrectly when moving the application window between screens.
Before troubleshooting, ensure your Windows operating system and Microsoft Office are updated to the latest versions, as recent patches often resolve graphical scaling glitches across multiple monitors.
Adjust Windows Display Scaling for Apps
Fix blurry or incorrectly rendered lines in Excel by forcing Windows to correct application scaling.
When using a laptop screen (e.g., 150% scaling) alongside an external monitor (e.g., 100% scaling), Excel may struggle to render fine UI elements like the double-line border. Enabling Windows scaling fixes can resolve this.
Right-click your Windows desktop and select 'Display settings'.
Scroll down to the 'Scale and layout' section and click on 'Advanced scaling settings'.
Toggle on the option that says 'Let Windows try to fix apps so they are not blurry'.
Close and restart Microsoft Excel, then check the Borders menu to see if the double lines render correctly.
Apply the Double-Line Border Manually
Even if the menu preview looks like a thick gray line, the double-line format is still active. You can apply it using the Draw Borders tool.
Apply Clear Double-Line Borders with WPS Spreadsheet
WPS Office offers a highly optimized spreadsheet interface that handles high-DPI scaling across multiple monitors seamlessly, ensuring all your border styles remain crisp and visible without visual glitches.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open your existing Excel file.
- 2. Access cell format: Select the cells you want to modify, right-click, and choose 'Format Cells'.
- 3. Apply double lines: Navigate to the 'Border' tab, select the double-line style under 'Line', and apply it to your desired borders. Click 'OK'.
Frequently Asked Questions
Why does my Excel double-line border look like a solid thick line?
This usually happens due to mismatched display scaling settings when using multiple monitors with different resolutions (e.g., a 1080p laptop screen at 150% and a 1200p monitor at 100%). Excel's UI compresses the two fine lines into what visually appears as a single gray line in the menu.
Does the thick gray line print as a double line?
Yes. In most cases, this is strictly a visual UI bug in Excel. If you apply the border and print the document or export it as a PDF, the double lines will render perfectly on the final document.
How can I quickly apply a bottom double border without opening the line style menu?
You can select the cell, navigate to the Home tab, click the Borders dropdown in the Font group, and simply select 'Bottom Double Border' from the preset options list.
Will changing my monitor's scale to 100% fix the Excel border issue?
Yes, matching the display scaling across all monitors (for instance, setting both to 100%) generally prevents Excel from incorrectly rendering thin UI elements like double lines when moving the application window between screens.
