How to Use the Right Border Shortcut (Alt + H + B + R) in Google Sheets

Use the Right Border shortcut from Excel (Alt + H + B + R) in Google Sheets

Right Border is a great way to visually separate columns in your analysis and is particularly helpful when performing calculations left to right in your spreadsheet. In this article, I will show you how to activate this feature in Google Sheets by shortcut, just like you would in Excel

The most common shortcut for Right Border in Excel is Alt + H + B + R. You can use this shortcut in Google Sheets by pressing & releasing Alt + H + B + R one after the other

Right Border Shortcut (Alt + H + B + R) in Google Sheets, just like Excel

Steps for Right Border:

1. Install the SheetWhiz Chrome Extension for free

2. Refresh a Google Sheet and login when prompted. The SheetWhiz logo will appear in the upper right hand corner of the screen

3. Select the area you'd like to apply a Right Border to and then hit Alt + H + B + R. Make sure you press and release each key before pressing the next key, just like you would in Excel

   1. If you are on a Mac, use Option + H + B + R as there is no Alt key on the Mac keyboard

4. In summary, the Right Border Shortcut:

   1. Alt + H + B + R (PC)

   2. Option + H + B + R (Mac)

5. [Optional] Furthermore, you can change the Right Border shortcut to a more convenient shortcut by clicking the button in the SheetWhiz menu and changing the key