Ask Your Question

How to change the appearance of printed grid lines? [closed]

asked 2017-07-07 20:38:05 +0200

printRick gravatar image

updated 2020-10-09 12:59:38 +0200

Alex Kemp gravatar image


When you enable the grid lines for printing in Format > Page > Sheet tab they get a thin black appearance by default. I would like to be able to change either their thickness/width to make them thicker, and/or their colour to make them dark grey instead of black.

For the colour I've tried in Options > Libreoffice > Appearance > Spreadsheet section by changing the colour of Grid lines from automatic to something else but they only change in the spreadsheet and not when printing or exporting to pdf. Even in the print preview they still remain black.

For the width/thickness I haven't found any setting or place to do so.

I'm aware of borders and their customization options but I would like to know about if black thin lines is the only option when you choose to print grid lines or if there is a way to change those.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 13:00:13.268440

1 Answer

Sort by » oldest newest most voted

answered 2017-07-08 00:57:08 +0200

librebel gravatar image

Hello @printRick,

The Grid color can be set in "Tools : Options... : LibreOffice Calc : View : Visual Aids : Color".

( i don't know how to change the grid line width )

edit flag offensive delete link more


If you change the colour from there and enable the grid for printing, does it keep the colour when printing or when in print preview?

printRick gravatar imageprintRick ( 2017-07-09 05:18:58 +0200 )edit

Selecting ShowGrid lines under Visual Aids only changes the screen experience.

To change for printing… May be you can fill a request for improvement at

LeroyG gravatar imageLeroyG ( 2020-08-12 21:02:08 +0200 )edit

Question Tools

1 follower


Asked: 2017-07-07 20:38:05 +0200

Seen: 1,214 times

Last updated: Jul 08 '17