How To Remove Dotted Lines In Excel

Removing dotted lines in Excel can be achieved by adjusting the border settings in the spreadsheet.

If you frequently work with Excel, you have likely encountered the frustration of dotted lines appearing in your spreadsheets. These lines can be distracting and make it difficult to focus on your data. Whether you are creating a report, analyzing data, or presenting information, removing these dotted lines can give your spreadsheet a cleaner and more professional appearance. In this blog post, we will explore various techniques and methods to remove dotted lines in Excel, helping you create visually appealing and tidy spreadsheets.

How To Remove Dotted Lines In Excel: Step-by-Step


Step 1: Open the Workbook

To remove the dotted lines in your Excel file, you will need to locate the file on your computer or cloud storage, open it using Microsoft Excel or a compatible software, and access the formatting options to remove or adjust the border style settings.

Next Step

Step 2: Select the Worksheet

Click on the worksheet tab at the bottom of the Excel window where the line exists to access and view the specific sheet containing the desired information or data in your Excel workbook.

Next Step

Step 3: Select the Cells

To remove dotted lines, click and drag to select the cells with dotted lines. For removing all dotted lines in the entire sheet, click the corner button between letter and number headers.

Next Step

Step 4: Open the ‘Go To Special’ Dialogue

To access the ‘Find & Select’ options, click on the designated button in the ‘Home’ tab. From the dropdown menu, choose ‘Go To Special…’ in order to proceed with specific selection criteria.

Next Step

Step 5: Select ‘Comments’

In the ‘Go To Special’ dialogue, choosing the ‘Comments’ option and clicking OK will highlight cells containing comments. This feature is useful for quickly identifying and working with cells that have comments attached to them.

Next Step

Step 6: Clear Comments

To remove comments from selected cells, right-click and choose ‘Clear Comments’ from the menu that appears.

Next Step

Step 7: Save the Workbook

To save changes, either use Ctrl+S (Windows) or Cmd+S (Mac), or go to File > Save in the workbook.


Removing dotted lines in Excel can greatly enhance the appearance and readability of your spreadsheets. By carefully following the steps outlined in this blog post, you can easily get rid of these distracting lines and create a more professional-looking document. Whether you choose to remove the gridlines, shading, or borders, Excel provides various options to help customize your spreadsheet based on your specific needs. Remember to save your changes and experiment with different formatting options to achieve the desired result. With a clean and polished spreadsheet, your data will be easier to understand and your presentations will have a more professional look. So go ahead and take control of your Excel spreadsheets by eliminating those troublesome dotted lines!

Table of Contents