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

Ask Your Question

Is there a quick way to add a thicker border to a selected group of cells? [closed]

asked 2018-07-17 11:43:40 +0200

markowe gravatar image

updated 2020-08-06 22:10:42 +0200

Alex Kemp gravatar image

Excel has this borders dropdown:

image description

It allows you to very quickly add a variety of different border types to a selected group of cells, including a "thick border". Although Libre has something similar:

image description

...these are the only options, and they are all 0.75pt borders. Am I right in thinking there is no way to change this, so we can QUICKLY select say, a "thick border"? I know I can select -> right-click -> format cells -> border and then change thickness to say 3pts, but that obviously takes a lot longer.

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-08-06 22:11:17.992922

1 Answer

Sort by » oldest newest most voted

answered 2018-07-17 12:19:26 +0200

Hot key is, Ctrl+1

edit flag offensive delete link more


Ah, thanks, that at least takes me to the border dialogue quicker. I still have to manually set the line width and then also select the "out border" button, so it's pretty slow for someone used to doing it in seconds. I guess I can make some kind of macro or style for that.

markowe gravatar imagemarkowe ( 2018-07-17 12:42:48 +0200 )edit

P.S. Made a macro in the end and added it as a toolbar button, easy-peasy.

markowe gravatar imagemarkowe ( 2018-07-17 12:54:43 +0200 )edit

Ah, nice! I will keep that in mind! Also (forgot) to repeat last edit. Ctrl + Shift + Y. I learned hot keys by looking at them on the pull downs.

Mark McLean gravatar imageMark McLean ( 2018-07-17 15:20:11 +0200 )edit

Question Tools

1 follower


Asked: 2018-07-17 11:43:40 +0200

Seen: 3,302 times

Last updated: Jul 17 '18