Download Article
Quickly hide divider lines or print lines in Microsoft Excel
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".
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.
Advertisement
-
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.
Advertisement
-
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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
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 .
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
Thanks for submitting a tip for review!
References
About This Article
Thanks to all authors for creating a page that has been read 29,876 times.
Advertisement
