3 Easy Ways to Get Rid of Dotted Lines in Microsoft Excel

PDF download Download Article
Quickly hide divider lines or print lines in Microsoft Excel
PDF download Download Article

Do you want to remove dotted lines in your Microsoft Excel spreadsheet? These dotted lines could be caused by page breaks for printing, stylized borders, or default settings. Luckily, these lines can be hidden in a few simple steps. This wikiHow will show you how to get rid of dotted lines on your Microsoft Excel worksheet using your Windows or Mac computer.

Things You Should Know

  • To remove dotted page break lines, go to "File" → "Options" → "Advanced" → uncheck "Show page breaks".
  • To remove border lines, select the cells. Click the "Borders" down-arrow, then "No Border".
  • Hide gridlines by clicking the "View" tab, then uncheck "Gridlines".
Method 1
Method 1 of 3:

Removing Page Breaks

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/21\/Get-Rid-of-Dotted-Lines-in-Excel-Step-1-Version-3.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/21\/Get-Rid-of-Dotted-Lines-in-Excel-Step-1-Version-3.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    After clicking "File," you'll see "Options" on the left panel at the very bottom.
    • Use this method to remove the dotted lines indicating a page break.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/39\/Get-Rid-of-Dotted-Lines-in-Excel-Step-2-Version-2.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/39\/Get-Rid-of-Dotted-Lines-in-Excel-Step-2-Version-2.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This is the left tab located between Accessibility and Customize Ribbon .
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/93\/Get-Rid-of-Dotted-Lines-in-Excel-Step-3-Version-2.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/9\/93\/Get-Rid-of-Dotted-Lines-in-Excel-Step-3-Version-2.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This checkbox is in the "Display options for this worksheet" section.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cd\/Get-Rid-of-Dotted-Lines-in-Excel-Step-4-Version-3.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/c\/cd\/Get-Rid-of-Dotted-Lines-in-Excel-Step-4-Version-3.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This will remove dotted lines from page breaks.
    5. Advertisement
Method 2
Method 2 of 3:

Removing Dotted Borders

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/41\/Get-Rid-of-Dotted-Lines-in-Excel-Step-7.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/4\/41\/Get-Rid-of-Dotted-Lines-in-Excel-Step-7.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If there's a dotted line bordering one or more cells, start by selecting the cells with dotted lines. Click and drag the mouse to select the cells, or press CTRL + A (Windows) or Command + A (Mac) to select all cells in the worksheet.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a3\/Get-Rid-of-Dotted-Lines-in-Excel-Step-8.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/a\/a3\/Get-Rid-of-Dotted-Lines-in-Excel-Step-8.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can find Borders in the Font section of the Home tab.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ed\/Get-Rid-of-Dotted-Lines-in-Excel-Step-9.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/e\/ed\/Get-Rid-of-Dotted-Lines-in-Excel-Step-9.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This will remove existing borders of any style, including dotted line borders.
    • If you used Excel to create a graph , this may make your graph less visible.
    4. Advertisement
Method 3
Method 3 of 3:

Removing Dotted Gridlines

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b1\/Get-Rid-of-Dotted-Lines-in-Excel-Step-10.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-10.jpg","bigUrl":"\/images\/thumb\/b\/b1\/Get-Rid-of-Dotted-Lines-in-Excel-Step-10.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can create a new worksheet or open an existing one.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Get-Rid-of-Dotted-Lines-in-Excel-Step-11.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-11.jpg","bigUrl":"\/images\/thumb\/8\/81\/Get-Rid-of-Dotted-Lines-in-Excel-Step-11.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This is the tab located between Review and Help .
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7b\/Get-Rid-of-Dotted-Lines-in-Excel-Step-12.jpg\/v4-460px-Get-Rid-of-Dotted-Lines-in-Excel-Step-12.jpg","bigUrl":"\/images\/thumb\/7\/7b\/Get-Rid-of-Dotted-Lines-in-Excel-Step-12.jpg\/v4-728px-Get-Rid-of-Dotted-Lines-in-Excel-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can find this in the Show section. You can also uncheck the Formula Bar and Headings to remove them if desired.
    4. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      4 Easy Ways to Add the Time and Date Automatically in Sheets
      How to Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
      The 3 Easiest Ways to Sort by Number in Google Sheets
      How to Make a Google Spreadsheet: Beginners Guide
      How to
      Add the Same Value to Multiple Cells in Excel
      How to
      Add Rows to a Pivot Table
      How to Add Custom Calculated Fields to Pivot Tables in Excel
      How to Use Google Sheets: The Ultimate Guide for Getting Started
      Easily Embed Documents and Files in an Excel Spreadsheet
      How to
      Add Two Cells Containing the Sum of Other Formulas in Excel
      3 Simple Ways to Create a Shared Spreadsheet
      How to Change the X Axis Scale in an Excel Chart
      How to
      Add a Row to a Table in Excel
      How to
      Create a Formula to Increase a Date by 1 Month
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d

      About This Article

      Thanks to all authors for creating a page that has been read 16,489 times.

      Is this article up to date?

      Advertisement