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.
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.
- 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.
- 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.
- 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.
- Finally, the above action will add the dotted border in the data set on your worksheet like the following image.
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.
- 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.
- Secondly, from the border choice dropdown, select any of the border style as they are all made with solid line.
- Thirdly, after choosing the style the dotted borders will be removed and replaced by solid borders.
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.
- 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.
- Secondly, in order to remove it, go to the File tab of the ribbon.
- Thirdly, you will see the Home window of Excel.
- From this window, select Options.
- 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.
- Finally, you will find your worksheet without any page breaks in it.
- How to Print Borders at Page Break in Excel (2 Quick Methods)
- [Fixed!] Table Border Not Showing in Print Preview (2 Solutions)
- How to Cancel Moving Border in Excel (4 Quick Tricks)
- How to Apply Borders in Excel with Conditional Formatting
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.
- First of all look at the following data set with gridlines around it.
- 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.
- 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
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.