Alt + H + B + A in Google Sheets (All Borders)
Draws a thin border around every cell in the selection, inside and out.
Add to Chrome (14 Days Free)In Excel: Home tab, Borders. In ShortieCuts' key-tip menu: "All Borders".
What Alt + H + B + A Does in Excel
Draws a thin border around every cell in the selection, inside and out.
How to Use Alt + H + B + A in Google Sheets
- Add the ShortieCuts extension to Chrome and open any Google Sheet.
- Select the cells you want to work on (if the command needs a selection).
- Press Alt (or Option on Mac). Excel-style key-tips appear over the sheet.
- Press H, B, then A. ShortieCuts runs All Borders, just like Excel.
Without an extension: Google Sheets doesn't support Excel's Alt key-tips, so Alt + H + B + A won't run All Borders on its own.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt HBS | Outside BordersDraws a thin border around the outer edge of the selection only. |
| Alt HBT | Thick Outside BordersDraws a thick border around the outer edge of the selection, the usual way to box a key output. |
| Alt HBO | Bottom BorderAdds a thin border along the bottom of the selection, often used under header rows. |
| Alt HBP | Top BorderAdds a thin border along the top of the selection, often used above a total row. |
| Alt HBL | Left BorderAdds a thin border along the left edge of the selection. |
| Alt HBR | Right BorderAdds a thin border along the right edge of the selection. |
| Alt HBN | No BorderRemoves every border from the selected cells. |
| Alt HBB | Bottom Double BorderAdds a double line under the selection, the accounting convention for a grand total. |
FAQ
Does Alt + H + B + A work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + H + B + A won't run All Borders. With the ShortieCuts Chrome extension installed, Alt + H + B + A works in Google Sheets the same way it does in Excel.
What does Alt + H + B + A do in Excel?
All Borders. Draws a thin border around every cell in the selection, inside and out.
How do I use Alt + H + B + A on a Mac?
With ShortieCuts, press Option instead of Alt, then H, then B, then A: Option + H + B + A. The same key-tips appear as on Windows.
Is ShortieCuts free?
ShortieCuts has a free 14-day trial with no credit card needed. After the trial, Pro is $7.99 a month or $69.99 a year.