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. After clicking "File," you'll see "Options" on the left panel at the very bottom. [1]
    • Use this method to remove the dotted lines indicating a page break.
  2. This is the left tab located between Accessibility and Customize Ribbon . [2]
    Advertisement
  3. This checkbox is in the "Display options for this worksheet" section. [3]
  4. This will remove dotted lines from page breaks.
    5. Advertisement
Method 2
Method 2 of 3:

Removing Dotted Borders

PDF download Download Article
  1. 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. [4]
  2. You can find Borders in the Font section of the Home tab.
  3. This will remove existing borders of any style, including dotted line borders. [5]
    • 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. You can create a new worksheet or open an existing one.
  2. This is the tab located between Review and Help . [7]
  3. You can find this in the Show section. You can also uncheck the Formula Bar and Headings to remove them if desired. [8]
    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

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      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
      How to
      Copy the Same Text to Multiple Cells in Excel: Desktop & Mobile
      How to
      Use Google Sheets: The Ultimate Guide for Getting Started
      How to
      Change the X Axis Scale in an Excel Chart
      How to
      Add Custom Calculated Fields to Pivot Tables in Excel
      The 3 Easiest Ways to Sort by Number in Google Sheets
      How to
      Add Rows to a Pivot Table
      Easily Embed Documents and Files in an Excel Spreadsheet
      How to
      Create a Formula to Increase a Date by 1 Month in Excel
      How to
      Make a Google Spreadsheet: Beginners Guide
      How to
      Add Two Cells Containing the Sum of Other Formulas in Excel
      How to
      Add Two Trend Lines in Excel
      How to
      Add a Row to a Table in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2
      2. ↑ https://support.microsoft.com/en-us/office/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2
      3. ↑ https://support.microsoft.com/en-us/office/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2
      4. ↑ https://edu.gcfglobal.org/en/excel/modifying-columns-rows-and-cells/1/
      5. ↑ https://edu.gcfglobal.org/en/powerpoint/tables/1/
      6. ↑ https://support.microsoft.com/en-us/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d
      7. ↑ https://support.microsoft.com/en-us/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d
      8. ↑ 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 32,244 times.

      Is this article up to date?

      Advertisement