A Libre Office Calc spreadsheet field shows a grid of black horizontal and vertical lines indicating the columns and rows. The problem is when I use a background color to highlight adjacent rows, all of these black grid lines disappear, which makes it difficult to tell which grid box an entry is in. Is there a way to use background color and still see the black grid lines? Thanks.
Yes. Click Tools > Options > LiibreOffice Calc > View and under Visual Aids change field Grid Lines from Show to Show on coloured cells
2 Likes
How do we do this in 2023? When I go to the Tools menu, I don’t have “Options” in that menu
Maybe you meant to say “Tools tab”? If a user doesn’t see Options then it is nearly always because the user has the Tabbed (ribbon) interface and does not have the menus visible. The usual advice then, is to click the Menubar icon at the very left of the icons, or possibly from a short menu somewhere at the right for some other interface variants, to toggle visibility of the menus.
Assuming you’re on macOS, they like to have that in their Application Preferences menu (or whatever it is called).
1 Like