How do I apply a thick border to one side of cell

I wanted to know how to apply say a thick right border to all selected cells on Excel, preferably using a shortcut. I tried recording a macro and then applying a thick border and erasing the top, bottom and left cells, but that just meant only the top cell had the right border, and the rest of the selection had left and right borders.

I only just discovered macros on excel so if there's a code I need to enter, if you wouldn't mind telling me what to do before and after I enter the code in order for it to work, that would be great.