How to Change Gridlines to Dash in Excel (with Easy Steps)

Gridlines are one of the most important features of any spreadsheet program as they provide a clear way to see where one cell begins and another one ends. They also help to align data in a certain way and make it easier to read. However, there may be times when you want to change the way your gridlines look. If you want to add a bit of variety to your Excel spreadsheet, you can change the gridlines from solid to dashed. In this article, I will show you how to change gridlines from solid to dash in Excel with ease.


Steps to Change Gridlines to Dash in Excel

If you open Microsoft Excel, by default you will see solid gridlines like the following picture. However, you can change the solid lines to dashes if you want. Now, I’m going to show you how to change the gridlines from solid to dash in Excel.


Step-1: Select Entire Worksheet

To change the gridlines from solid to dash, you need to select the entire worksheet first.

For that,

  • Click on the triangle icon on the top-left corner of your worksheet.

This will highlight the entire worksheet of your workbook.


Step-2: Open Format Cells Dialog Box

To avail of the gridline modification options, you need to go to the Format Cells dialog box. There are multiple easy ways to open the Format Cells dialog box. I’m describing all of them one by one.

  • First, you can go to the Home tab in the ribbon.
  • Then click on the Borders drop-down option in the Font group.
  • From the drop-down list, click on the More Borders option.

Change Gridlines to Dash in Excel

Now you will see that the Format Cells dialog box has opened with the Border selected.

You can also press the CTRL + 1 keys to open the Format Cells dialog box.


Step-3: Switch from Solid to Dash Gridlines

After opening the Format Cells dialog box, you need to follow a few steps to change the gridlines from solid to dash in Excel.

To change the gridlines from solid to dash,

  • Select the Border tab in the Format Cells dialog box.
  • Select a dashed line from the Style box.
  • After that, select the Inside command in the Presets section.
  • Finally, click OK to apply the changes.

Change Gridlines to Dash in Excel

Finally, the gridline style will change from solid lines to dashed lines. The output will look like the following picture.

Change Gridlines to Dash in Excel


Advantages of Changing Gridlines from Solid to Dash in Excel

There are a few advantages to changing your gridlines from solid to dashed. First, it can help to make your data stand out more. Solid lines can sometimes blend in with the data, making it harder to see. Dashed lines, on the other hand, will always be visible and can help to highlight certain cells or data points.

Another advantage of dashed lines is that they can help to make your spreadsheet look neater. This is because they don’t have the solid, straight edges that solid lines do. Dashed lines can help to break up the monotony of a spreadsheet and make it look more interesting.

Overall, there are a few advantages to changing your gridlines from solid to dashed. These include making your data stand out more, making your spreadsheet look neater, and breaking up the monotony of a spreadsheet.


Conclusion

To sum up, we have discussed steps to change gridlines to dash in Excel. Please don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo