Why do the grid lines not show when I apply a background color to a column?
1 Like
Go ‘Tools’ > ‘Options’ > ‘LibreOffice Calc’ > ‘View’ > ‘Visual Aids’ > ‘Grid lines:’ and select ‘Show on colored cells’. (Read: ‘Show aslo on colored cells’.)
1 Like
Worked like a charm! Thanks and regards from Ottawa (where it’s NOT snowing!!!)
You are welcome.
(You may click the check mark to point others to a valid answer.)
Regards from München (2.7° north of you in latitude) where the sun is shining (7°C).
I opened an excel file with already colored cells. However when remove the color or set it to white, there’s still no grid. Grid works with other colors though.
Found a solution, needed to highlight the cells, right-click and choose clear direct formatting (not sure of the English translation)