How to Use Border Shortcuts (Alt + H + B) in Google Sheets

Use all the border shortcuts from Excel in Google Sheets

Adding and removing borders in Google Sheets is one of the most common formatting shortcuts. It is one of the easiest and best tools to organize your analysis. In this article, I will show you how to activate every border tool in Google Sheets by shortcut, just like you would in Excel

Steps to activate Border Shortcuts:

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

4. The border shortcuts are below. Make sure you press and release each key before pressing the next key, just like you would in Excel:

   1. Remove Borders:

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

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

   2. Top Border:

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

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

   3. Bottom Border:

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

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

   4. Right Border:

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

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

   5. Left Border:

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

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

   6. Outside Border:

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

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

   7. All Borders:

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

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

   8. Inner Borders:

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

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

   9. Horizontal Borders:

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

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

   10. Vertical Borders:

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

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

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