How do i get default excel gridlines back?

Question

Recently both my work and personal 365 accounts have experienced the same issue, new excel workbooks and sheets have no gridlines.

I can navigate to Options > advanced and change the colour from automatic white to black but then they are dotted lines and revert back on any new sheet or workbook.

I have followed multiple articles on this same issue but to no avail, registry editor doesn't solve it and I am unable to locate my XLstart folder on either machine.

The issue seems to be that the automatic gridline colour changed from grey/black to white at some point and changing this leads to a dotted line. I presume this is due to a lack of a default workbook in my non-existent XLStart folder which I can't find a resolution for online.

Any help would be greatly appreciated.

**Nevermind.... I have discovered this is caused by the contrast on my monitor being too high. I feel stupid but hopefully someone else out there has the same issue and this can help them, making me feel less stupid.

Answer 1

Dear Rhys_1312,

Welcome to Microsoft Community.

Thank you for choosing to use Microsoft Excel and confirming your gridline function.

We noticed that you mentioned that your problem was solved after changing the contrast of your monitor to see the information in the work wave. We appreciate your sharing as your method also provided us with valuable insights to solve the problem.

We will also record the solution you shared to help other users. Thank you for sharing your ideas and suggestions, which are essential to improving Microsoft products. We will continue to pay close attention to the information you share with us.

If you have any other further updates or questions in the future, please feel free to get back to us.

Best Regards,

Zenobia.Z | Microsoft Community Support Specialist