Download Article
Download Article
This article was co-authored by wikiHow staff writer, Rain Kengly. Rain is a tech writer and editor for wikiHow with over 5 years of professional writing experience. In the past, Rain has worked with other creative writers as a Writing Tutor at San Francisco State University and has published gaming features, guides, and news articles for a variety of media outlets. Rain shares a lifelong passion for writing and gaming and is eager to grow alongside new tech inventions.
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 39,193 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 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".
Steps
-
Click the File menu and select Options. 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.
-
Click Advanced. This is the left tab located between Accessibility and Customize Ribbon.[2]Advertisement -
Scroll down and uncheck "Show page breaks." This checkbox is in the "Display options for this worksheet" section.[3] -
Click OK. This will remove dotted lines from page breaks.
-
-
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.[5]- 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.[6]
-
Click View. This is the tab located between Review and Help.[7] -
Uncheck "Gridlines." You can find this in the Show section. You can also uncheck the Formula Bar and Headings to remove them if desired.[8]- You can now use Excel with gridlines hidden. This could be helpful if you want to use complex formulas.
Expert Q&A
Video
Tips
You Might Also Like
References
- ↑ https://support.microsoft.com/en-us/office/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2
- ↑ https://support.microsoft.com/en-us/office/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2
- ↑ https://support.microsoft.com/en-us/office/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2
- ↑ https://edu.gcfglobal.org/en/excel/modifying-columns-rows-and-cells/1/
- ↑ https://edu.gcfglobal.org/en/powerpoint/tables/1/
- ↑ https://support.microsoft.com/en-us/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d
- ↑ https://support.microsoft.com/en-us/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d
- ↑ https://support.microsoft.com/en-us/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d
About This Article
