How to Add or Remove Dotted Border in Excel (4 Easy Ways)

A dotted border is a feature of Microsoft Excel. It may be present in the worksheet by default or by manipulating some commands or options in Excel. In this article, I will show you how to add or remove dotted border in Excel.


Download Practice Workbook

You can download the free Excel workbook here and practice on your own.


Dotted Border in Excel

The dotted border is not a permanent feature of Excel. You may add the border or remove or replace  them as per your preference. Sometimes, users face some issues like unable to remove dotted page break lines or gridlines. So, in this article, you will see how to add and remove dotted border in Excel.

For showing this procedures, I will use the following data set.

Easy Ways for Adding and Removing Dotted Border in Excel


An Easy Way to Add Dotted Border in Excel

The way to add a dotted border in Excel. For that you have to follow some particular steps. See the below given steps for adding dotted border in Excel.

Step 1:

  • First of all choose the data set or a single cell around which you will add the border.
  • Then, go to the Home tab of the ribbon and in the Font group, click on the border icon.

Step 2:

  • Secondly, the previous step will show you many border choices in a dropdown like the following picture.
  • In order to add dotted border, select More Borders.

Step 3:

  • Thirdly you will see the Border tab opened of the Format Cells dialog box.
  • Then , from the Style header select the first border style with a dotted line.
  • After that, from the Presets header, select the later two presets to apply dotted border in the whole data range.
  • Lastly, press OK.

Modifying Format Cells Dialog Box to Add Dotted Border in Excel

Step 4:

  • Finally, the above action will add the dotted border in the data set on your worksheet like the following image.

Showing Final Result of Adding Dotted Border in Excel


3 Easy Ways to Remove Dotted Border in Excel

In this section, I will show you three easy ways to remove dotted border from Excel. Along with the dotted borders, sometimes users face issues with page break line and grdilines. So, I will include the process of removing them in this section.


Method 1: Removing Dotted Cell Border

Unnecessary dotted borders are odd for visual representation of data set in Excel. By following some simple steps you can replace or remove it. For that, see the following steps.

Step 1:

  • First of all, select the data set with dotted border and go to the Home tab of the ribbon.
  • Then in the Font group, select the border icon.

Step 2:

  • Secondly, from the border choice dropdown, select any of the border style as they are all made with solid line.

Choosing New Border Style for Removing Dotted Border in Excel

Step 3:

  • Thirdly, after choosing the style the dotted borders will be removed and replaced by solid borders.

Read More: How to Remove Borders in Excel (4 Quick Ways)


Method 2: Withdrawing Dotted Page Break Line

One of the most annoying issues regarding dotted borders is the dotted page break line. It may appear in the data set after pressing the print command to print the sheet. If the page break line is unnecessary, you can withdraw it by following the below-given steps.

Step 1:

  • Firstly, see the following image with a dotted page break line in it.
  • As, it will not remove normally, I will show the exact procedure in the following steps.

Step 2:

  • Secondly, in order to remove it, go to the File tab of the ribbon.

Step 3:

  • Thirdly, you will see the Home window of Excel.
  • From this window, select Options.

Step 4:

  • Thirdly, in the Excel Options dialog box, go to the Advanced tab.
  • Then, under the Display options for this worksheet, uncheck Show page breaks.
  • Lastly, press OK.

Modifying Excel Options for Withdrawing Dotted Page Break Line in Excel

Step 5:

  • Finally, you will find your worksheet without any page breaks in it.

Read More: How to Remove Page Border in Excel (3 Methods)


Similar Readings


Method 3: Removing Dotted Gridlines

The last method will highlight on removing dotted gridlines from a worksheet. Though the gridlines are not dotted, it can be assumed as one. To remove or turn off gridlines in a worksheet, follow the below-given steps.

Step 1:

  • First of all look at the following data set with gridlines around it.

Step 2:

  • Secondly, to turn it off, go to the Show group under the View tab of the ribbon.
  • Then uncheck the box that appears before Gridlines feature.

Step 3:

  • Finally, the previous action will remove or turn off the dotted gridlines from the worksheet.

Read More: How to Add or Remove Cell Borders in Excel


Conclusion

That’s the end of this article. I hope you find this article helpful. After reading the above description, you will be able to add or remove dotted border in Excel. Please share any further queries or recommendations with us in the comments section below.

The ExcelDemy team is always concerned about your preferences. Therefore, after commenting, please give us some moments to solve your issues, and we will reply to your queries with the best possible solutions ever.


Related Articles

Araf

Araf

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo