We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is there way to add thickness to all lines in table? [closed]

asked 2014-06-07 09:57:25 +0200

etki gravatar image

updated 2014-06-08 16:17:01 +0200

Pedro gravatar image

After importing excel table to calc lines is thinner. After print is not visible. Is there way to add thickness to all lines in document at once?

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 2016-02-24 20:55:22.121487

2 Answers

Sort by » oldest newest most voted

answered 2014-06-08 09:50:36 +0200

Pedro gravatar image

updated 2014-06-08 16:16:33 +0200

There is currently no way to change the thickness (or colour) of all borders set in a range of cells. To my knowledge there is no way to do this on any spreadsheet program.

You can either remove or change the border of all cells in a range, but you can not change the border of the cells that already have a border defined without changing those that you do not want to have borders.

Example: it would be nice to select all cells in a table like this
Simple table
and simply increase the border width for all lines simultaneously.

It would be a very useful addition to any spreadsheet program!
You can make a request for adding such feature at

edit flag offensive delete link more


@Pedro - I think it is possible. See my Edtit2

ROSt52 gravatar imageROSt52 ( 2014-06-08 10:36:07 +0200 )edit

@ROSt52, there is no Edit2 in your answer. If there is a way, I would like to know.

Pedro gravatar imagePedro ( 2014-06-08 10:42:42 +0200 )edit

@Pedro - Please have a look now. I am not witch and need the time of a human. May be I am bit slow... ;-). Pedro, may I ask you for your comment to my Edit 2? This would help me to understand my answer better. Thanks in advance.

ROSt52 gravatar imageROSt52 ( 2014-06-08 10:47:33 +0200 )edit

@ROSt52, I didn't mean to rush you. It would have made more sense to add Edit2 and only after make a comment to me ;) You still have not understood what the user asked. I will add an image to my own answer to illustrate.

Pedro gravatar imagePedro ( 2014-06-08 14:43:47 +0200 )edit

@Pedro - One can argue about " Is there way to add thickness to all lines in document at ones?". The example you show can also be done with only 2 areas which you need to select and format. I tried to show the principle --- It is fine with me as it is.

ROSt52 gravatar imageROSt52 ( 2014-06-08 15:53:39 +0200 )edit

answered 2014-06-07 10:10:31 +0200

ROSt52 gravatar image

updated 2014-06-08 10:49:56 +0200

Here is the way to do it:
- Select the cells for which you want to change the border
- Right click in the selected area > format cells > tab border
there you can set the borders the way you need it.

"Select the cells" can be one cell or more than one cell or all cells. All can be done in 1 step except when not connected areas need to be selected.

If you need help in selecting many or all cells, please advice.

Additionally I can recommend to read the free manual which you can download here: http://www.libreoffice.org/get-help/d...

Example of an cell area formated in 1 activity to thicker and pink frame.
image description
and this is where to do it:

image description

The same can be done with areas of cells not connected to each other; note here that the right border of the 3 areas have a different line style even. image description

If you want to do such formatting for the entire sheet, please select all cells by clicking into the top left corner of the spreadsheet (red frame):
image description

edit flag offensive delete link more


this is not what i need. I have complicated table with variable kind of line thickness. This way is too slow. I need add 3pt to all lines at ones

etki gravatar imageetki ( 2014-06-07 20:27:18 +0200 )edit

If the formatting concerning cell borders is done by assigning deliberately defined cell styles, may it be fixed or conditional, it is easy: Rework the styles. If borders are set by direct formatting there won't be an easy way. The occasion might trigger a slight change in habits.

Lupp gravatar imageLupp ( 2014-06-08 16:41:52 +0200 )edit

Question Tools

1 follower


Asked: 2014-06-07 09:57:25 +0200

Seen: 2,352 times

Last updated: Jun 08 '14