Gridline styles in Excel

Question

Why do some workbooks have dotted gridlines while others have solid gridlines? How do I change the gridline style?

Answer 1

That is the cell border style. This page has info on it:

https://support.office.com/en-us/article/create...

Answer 2

Thank you but I am quite familiar with borders and border colours and styles. As shown below I have screen clippings from two different workbooks. One has dotted gridlines in addition to border colours and styles and the other has solid gridlines in addition to border colours and styles. The gridline style is what I want to know how to change, if I can. If I can't, I want to know why the difference in the two workbooks. What would cause this behaviour?

Below is a grid of cells from a workbook with different border colours and styles applied. Note that the gridlines are dotted.

Below is the same cell grid from a different workbook with the same border colours and styles applied but as you can see the gridlines are solid, not dotted.

Any help would be greatly appreciated.

Answer 3

Are you talking about the horizontal grid lines or vertical?

All the grid lines are the same in both images, except the colour of the vertical lines.

Answer 4

Both. On my end, the gridlines are not the same. In both images the top and bottom borders that are applied are thick green and the horizontal internal borders are long dash-short dash orange. Vertical borders are solid thin black. The gridlines are gray. I have since discovered that, by changing the gridline colour and then changing it to automatic, the gridlines changed to a solid line in the workbook that had previously displayed dotted gridlines.