• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Get Droid Tips

Get Droid Tips

Custom ROM | CyanogenMod | Android Apps | Firmware Update | MiUi | All Stock ROM | Lineage OS |

  • Android
  • Games
  • iPhones/iPad
  • Social Media
  • Windows
  • LineageOS 17.1
  • Android 10
  • iOS 14
  • Free Among Us for PC
  • Write for US
  • Watch IPL 2020 For Free
Home PC Tips and Tricks

How To Remove The Dotted Lines In Excel

Updated on December 25, 2020 by Swayam Prakash

Advertisements

Sometimes while using Microsoft Excel you may come across cells showing as dotted lines. There are certain reasons why this happens. In this guide, I have explained the reason for seeing the dotted line and how to remove them. Mainly due to page breaks, setting borders with dots and guidelines can cause this.

There are a few tweaks you need to do to fix the issue. You can disable the page breaks. Also, make sure that the borderlines of the cell in the worksheet are not set to show as dotted lines. Another solution is to set no border for the excel sheet. Let’s get ahead with the guide and check out the steps in detail.

How to remove dotted lines in Microsoft Excel

Remove The Dotted Lines In Excel

First, let us check how to remove dotted lines from the border.

Advertisements
  • Select the cells in the worksheet from which you want to remove dotted lines
  • Click on Home from the menu bar
  • Next, click on the Border font drop-down button
    Set no border in Microsoft Excel to remove dotted lines
  • From the drop-down menu, click on No Border

If you wish to replace the dotted lines with other types of the border such as top/bottom/left/right then you can select that as well from the above drop-down menu.

Remove the Gridlines

Gridlines and dotted lines are not the same things. Gridlines may be set to the entire worksheet.

To disable that,

  • Click on View from the menu bar
    Remove gridlines from Microsoft Excel
  • Uncheck the option Gridlines under the Show tab

This will remove the gridlines throughout the worksheet. Later, if you wish to implement gridlines on your worksheet, then go to View > Show and simply check the option Gridlines.

Disable Page Break

Normally, page break helps in keeping the worksheet properly organized by breaking it into sections. You can simply close and re-open the workbook to automatically remove the page break.

  • Click on File > More > Options
    Microsoft Excel click File and then Options
  • Navigate to the Excel Options dialog box
  • In the left-hand panel click on Advanced
  • Scroll down to Display Options for This Worksheet
    uncheck show page breaks to remove dotted lines in Microsoft Excel
  • Uncheck the option Show Page breaks
  • Click OK

So, these are the various methods to easily remove the dotted lines showing up on the Microsoft Excel worksheet.

Advertisements

More Guides on Excel,

  • How to Make Pie Chart in Microsoft Excel
  • Not Able to Attach Excel file to Email: How to Fix
  • Learn the Best Microsoft Excel Shortcuts

Tagged With: Microsoft Excel

Primary Sidebar

Buying Guide

Top 6 Smartphones on Black Friday Deals 

Best Motherboards for the AMD Ryzen 9 5900X

Best Power Supply Unit (PSU) For Nvidia RTX 3090, 3080, And 3070 GPU

Best 3D Mu6 Dummy Head Recording Earphone

Best Hidden Cams To Buy in 2020

60Hz vs 144Hz vs 240Hz Monitors – Differences and Purchase Guide

How To Use PayPal On Amazon To Shop Safely?

RTX 3070 vs 3080 vs 3090: Differences, Performance, Design, Price, and More

Geforce RTX 3080 and RTX 3090 Pre-Order Guide: Where To Buy in India

How Much Will it Cost in India for Nvidia GeForce RTX 3070 / 3080 / 3090?

Advertisements
Advertisements

Footer

Signal Private Messenger Alternatives for Android and iPhone

How to Change Android DNS Settings

Download Google Camera for Samsung Galaxy M12 [GCam APK]

How to Change Google Drive Backup and Sync Folder Location

How to Stop Signal From Telling You When Your Contacts Join

Download Google Camera for Oukitel C22 [GCam APK]

Download Latest Disney+ APK v1.11.3+ | Added All Language List

Fix: Cannot Delete Key: Error While Deleting Key on Windows 10

How to Fix Your Slow SSD on Windows 10

How to Recover PowerPoint Password on Windows 10

How to Switch Windows Hello Login method from PIN to Password?

Best CSV File Viewer Software for Windows 10

How to Disable Adobe Acrotray.exe from Startup

How to Use Microsoft’s PowerToys on Windows 10?

How To Add New WhatsApp Contact Using QR Code

Wondershare Document Cloud – All Around Document Solution

What is Doordash Error Code 400 and How to Fix It?

Why Does Zoom Error Code 3113 Appears and How to Fix?

Zoom Error 2011 | What This Error Code Mean and How To Fix it?

How to Find If Someone Deleted your Conversation on Snapchat

How to Activate Discovery Plus on TV

© 2021 · Get Droid Tips

  • About Us
  • Contact Us
  • Privacy Policy
  • Disclaimer
  • Editorial Policy
  • Terms of Use
  • Write for Us