Ask Your Question

Calc: How do I show gridlines in a spreadsheet if there is no option in tools

asked 2019-11-22 16:44:21 +0100

grammie5353 gravatar image

updated 2019-11-22 16:54:11 +0100

Grantler gravatar image

In the answers to "how do I show gridlines on a spreadsheet, it says to go to Tools, the options, however, when I click on Tools, there is no "option" selection.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-11-22 16:56:24 +0100

Grantler gravatar image

Hit ALT + F12 - don't you get any Options panel?

If yes, proceed to LibreOfficeCalc | View | Visual Aids :: Grid Lines :: Show

edit flag offensive delete link more


I have followed the procedure above, however, all this does is show the gridlines on the spreadsheet. The problem I'm having is I can't get the gridlines to show up when I print the spreadsheet. I am at a loss as to how to do this.

grammie5353 gravatar imagegrammie5353 ( 2019-11-24 00:16:51 +0100 )edit

answered 2019-11-22 16:55:47 +0100

keme gravatar image

updated 2019-11-22 18:22:09 +0100

... when I click on Tools, there is no "option" selection.

Then you are using a Mac.

For the Mac version of LibreOffice, the general settings dialog, Options, has been moved to the application menu (just after the Apple menu ; menu name Calc in this case) and renamed Preferences in keep with the established standards for Mac software, so as not to disturb the average Mac user (I think that must have been the general reasoning ;-) ).

So Calc - Preferences it is.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-22 16:44:21 +0100

Seen: 37 times

Last updated: Nov 22