top of page
Writer's pictureDavid Pang

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
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
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

Customize the border shortcuts with SheetWhiz





26 views0 comments

Comments


bottom of page