As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Removing Dotted Lines in Excel

If you're dealing with a data-filled worksheet, you might seek to clear the dotted lines that separate cells. These lines can clutter the view and hinder readability. Fortunately, Excel provides various methods to eliminate these lines. Here's how to do it:

Method 1: Conceal Gridlines

To eliminate the dotted lines, consider hiding the gridlines. This doesn't delete the lines but renders them invisible. Follow these steps:

  1. Open the intended worksheet.
  2. Access the "View" tab.
  3. Click on the "Gridlines" button within the "Show" group to hide the gridlines.

Now, your worksheet won't display gridlines. To re-enable them, repeat the process and click on the "Gridlines" button.

Method 2: Erase Gridlines

To entirely remove gridlines, follow these steps:

  1. Open the worksheet.
  2. Navigate to the "File" tab.
  3. Choose "Options" at the bottom.
  4. Go to "Advanced" in the sidebar.
  5. Locate the "Show gridlines" option under the "Display" section. Change it from "Yes" to "No" and click "OK".

This action deletes the gridlines. To restore them, revisit the settings and revert the "Show gridlines" option to "Yes".

Method 3: Clear Gridlines in Specific Cells

If you only want to remove gridlines from a selected cell range, do the following:

  1. Select the desired cell range.
  2. Access the "Home" tab.
  3. Click on the "Borders" button within the "Font" group.
  4. Select "No Border".

This action eliminates gridlines in the chosen cell range. To reapply them, repeat the process and select the "Borders" button.

Method 4: Utilize VBA for Gridline Removal

For a bulk removal of gridlines across multiple worksheets, utilize a VBA macro:

  1. Open the workbook.
  2. Press Alt+F11 to access the Visual Basic editor.
  3. Click on "Insert" and select "Module".
  4. Paste the provided code.
  5. Press F5 to run the macro.

This VBA script removes gridlines from all worksheets. To restore them, rerun the macro following the provided steps.


The article outlined four methods to eliminate dotted lines in Excel. It also explained how to utilize a VBA macro to remove gridlines from multiple worksheets simultaneously. For further queries or comments, feel free to reach out.