Forum Discussion
Line thickness
It sounds like you’re trying to change the thickness of the gridlines in an Excel worksheet. Unfortunately, there is no built-in way to change the thickness of the gridlines in Excel.
The gridlines are meant to be a visual aid and their appearance cannot be modified.
However, there are a few workarounds that you can use to achieve a similar effect.
One way is to remove the gridlines altogether and use borders instead.
You can format the borders to have the desired thickness and color.
Here’s how you can do this:
- Select the cells that you want to add borders to.
- Click on the Home tab in the ribbon.
- In the Font group, click on the Borders button.
- From the drop-down menu, select More Borders.
- In the Format Cells dialog box that appears, select the Border tab.
- Under Style, select the desired line style and thickness.
- Under Color, select the desired line color.
- Under Border, click on the buttons to add borders to the selected cells.
- Click OK to apply the formatting.
I hope this helps!
Hi NikolinoDE
Thanks for your response.
I'm not trying to change the thickness of the grid lines. When Print is selected, the gridlines actually print at about the line weight I would like, however they don't show up over any cells that have a fill, so aren't much use.
The line weight I am trying to change is in fact the borders. They print very thick. I would like them to appear more like the gridlines.
I've been in touch with Microsoft however they have escalated my case. I'm very surprised that it's not an option to make these lines lighter.
Thanks again.
