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

Ask Your Question

Calc - Way to set default Border outline width thickness? [closed]

asked 2016-08-27 21:43:46 +0200

miketurn gravatar image

Hello Everyone,

I mentioned some ideas for border tools in another post of mine, but in the mean time, does anyone know of a way to set a default border outline thickness. So say you want to set any cells you want to add a border to, to a width of 2.00 pt. This way every time you create an outline it automatically is set to 2.00 pt. With the ability of having this setting always be set even for new spreadsheets.

Thank You

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-11 08:30:13.496417

2 Answers

Sort by » oldest newest most voted

answered 2016-08-27 23:39:13 +0200

updated 2016-08-27 23:41:42 +0200

I would use styles. You create a cell style with the thickness of the desired edge. Every time you apply that style to the cells you set the correct edge. If you then want to make the default for all your files, you create a template as you have indicated in the Floris answer.


edit flag offensive delete link more


This doesn't seem to work if you want one border encompassing multiple cells or different cells have borders on different sides, of different colours etc. Because a cell style defines the line arrangement, border colour and border thickness all together.

Bloopy gravatar imageBloopy ( 2020-02-25 01:17:12 +0200 )edit

answered 2016-08-27 23:12:31 +0200

floris v gravatar image

Make a blank Calc file with the formatting settings that you want, then save it as your default template (File - Templates - Save as template, tick Set as Default template).

If this answer helped you, please vote it with ✔ (here on the left). That will help other people with the same question.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-08-27 21:43:46 +0200

Seen: 1,281 times

Last updated: Aug 27 '16