Ask Your Question

Struggling with Border around selection

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

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

1 Answer

Sort by » oldest newest most voted

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

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 86 times

Last updated: Aug 13 '16