This article was co-authored by How.com.vn staff writer, Rain Kengly. Rain Kengly is a How.com.vn Technology Writer. As a storytelling enthusiast with a penchant for technology, they hope to create long-lasting connections with readers from all around the globe. Rain graduated from San Francisco State University with a BA in Cinema.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 12,135 times.
Learn more...
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 How.com.vn 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".
Steps
- Click the File menu and select Options. 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.
- Click Advanced. This is the left tab located between Accessibility and Customize Ribbon.Advertisement
- Scroll down and uncheck "Show page breaks." This checkbox is in the "Display options for this worksheet" section.
- Click OK. This will remove dotted lines from page breaks.
- Highlight the affected cells. 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.
- On the Home tab, click the "Borders" drop-down arrow. You can find Borders in the Font section of the Home tab.
- Click No Border on the menu. 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.
- Open a worksheet in Microsoft Excel. You can create a new worksheet or open an existing one.
- Use this method to remove the faint gridlines that appear between the cells on the worksheet.[1]
- Click View. This is the tab located between Review and Help.
- Uncheck "Gridlines." You can find this in the Show section. You can also uncheck the Formula Bar and Headings to remove them if desired.
- You can now use Excel with gridlines hidden. This could be helpful if you want to use complex formulas.
Expert Q&A
Tips
References
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.