How do assign an OUTSIDE only border style to a group of cells?

Question

How do assign an OUTSIDE only border style to a group of cells?

Rowena Dennis 0

Hello!

I've used Cell Styles to create a border, but I only want the formatted border to apply to the outside of a group of cells - not the inside.

The effect is what I have created here manually - is there any way of doing it? It is for a rolling roster which is on a 3-weekly repeat so I'm wishing to create a 'look' for each week.

User's image

AllenXu-MSFT 24,951 Reputation points Moderator

2023-08-24T02:41:36.68+00:00

@Rowena Dennis,

Is there any answer helps in this case? Please let us know if you still need help.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

2 answers

Your answer

AllenXu-MSFT 24,951 Reputation points Moderator

2023-08-24T02:41:36.68+00:00

@Rowena Dennis,

Is there any answer helps in this case? Please let us know if you still need help.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

Viorel 122.6K

For example:

Sheet1.Range("B3:G4").BorderAround LineStyle:=XlLineStyle.xlContinuous, Weight:=XlBorderWeight.xlMedium, Color:=RGB(255, 0, 0)

See:

https://learn.microsoft.com/en-us/office/vba/api/Excel.Range.BorderAround

Answer 2

Tanay Prasad 2,250

Hi,

To add an outside border, click on the Borders Icon.

Then under Draw Borders, click on Line Style and choose a color.

Line Style under Draw Border in Excel

You can then draw your border around whichever cells you want to.

Best Regards.

Share via

How do assign an OUTSIDE only border style to a group of cells?

2 answers

Your answer