Ask Your Question
1

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

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

markowe gravatar image

updated 2018-07-17 11:44:54 +0200

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 close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

Hot key is, Ctrl+1

edit flag offensive delete link more

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 307 times

Last updated: Jul 17 '18