Ask Your Question

Struggling with Border around selection [closed]

asked 2016-08-13 07:33:01 +0100

Kitfox gravatar image

updated 2020-08-06 14:38:31 +0100

Alex Kemp gravatar image

I am trying to create a Style so that I can have thick borders like I get in Excel. I can setup a border around a cell but I need to have a border around a selection of cells. I have tried to select a group of cells and then go to Styles & Formatting and create a new Style. Unfortunately, this only shows me the options for a single cell and not a selection of 2X2 or more like I can see if I just go to formatting.

How can I create a Border style that is just a thick border around the selection and not for every cell in the selection?

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 14:38:43.117712

1 Answer

Sort by » oldest newest most voted

answered 2016-08-13 22:09:37 +0100

paul1149 gravatar image

Perhaps the best way is to select your cells, then go Tools / Macro / Record Macro. In Record mode, right-click the cells and format them the way you want. Stop Recording and save the macro. Now you can assign the macro a hotkey, place it in a toolbar, or add it to a menu or the context menu.

edit flag offensive delete link more



Thanks! For others that try to do this, you may need to enable Macro Recording first.

Kitfox gravatar imageKitfox ( 2016-08-14 00:22:09 +0100 )edit

Question Tools

1 follower


Asked: 2016-08-13 07:33:01 +0100

Seen: 128 times

Last updated: Aug 13 '16