How to get rid of dotted lines in Excel

If you are a regular excel user, you should know how important it is to maintain a clean and well-arranged spreadsheet clean. It doesn't matter whether your documents are for personal use or official. The chances are that the dotted lines are unappealing to the eyes and can mess out of your work. Removing the dotted lines from your excel spreadsheet is a very straightforward task. It only takes a few steps:

Cells and groups of cells are usually merged as one on excel, but it is not impossible to change the style of the borders.

You can quickly do that by clicking on the Home tab by the top of the excel window. Proceed by selecting the dropdown menu of the borders. The drop-down contains various options, and from there, you can change from dotted lines to borderlines. You can even decide to do away with the borders.

Table of Contents

Example 1

1. The sheet below contains dotted lines set by formatting the borders

2. Highlight all the dotted Lines

3. Right-click and select format cells

4. Navigate to border

5. Choose a line then choose inside or use the boxes to fill the lines

6. The lines will be removed automatically

Example 2 

You should notice that excel shows the grid and borderlines. I mean, the lines around your cells and columns. You can decide to remove those lines if you want your work to be devoid of lines or dots.

1. Select your data and check the top menu bar and click the "view tab."

2. Take a look at the gridline box and untick the checkmark

Page break is the major cause of strange dotted lines on your spreadsheet.

3. You can remove the page break by selecting the cell and row that follows it immediately.

4. Go to the top menu and click the "page layout tab."

5. Locate the page setup group and select "break."

6. A dropdown menu will open. Check the dropdown menu; you will see an option to remove page break.

7. You do this immediately; your spreadsheet will be devoid of the dotted lines and will look cleaner than ever before.

I hope you understand the explanations above. If you love this tutorial, kindly share it with friends and leave your comments in the box below.