Borders – Microsoft Excel Shortcuts
200 Excel Shortcuts for PC and Mac
So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we’ve curated 200 of the best Excel keyboard shortcuts.
Borders
The design and aesthetics of your Excel spreadsheet is important. With these simple shortcuts you will be able to add custom borders to any cells you choose.
| Shortcut | Windows | Mac |
|---|---|---|
| Add cell border While working on the aesthetics of your spreadsheet, this shortcut is useful in separating cells from each other in an organized fashion. When used, a four-sided border will appear around all cells in your selection. | Ctrl Shift & | ⌘ Option 0 |
| Toggle right border Add or remove the border on the right side of selected cells. | Alt R | ⌘ Option ► |
| Toggle left border Add or remove the border on the left side of selected cells. | Alt L | ⌘ Option ◄ |
| Toggle bottom border Add or remove the border on the bottom of selected cells. | Alt B | ⌘ Option ▼ |
| Toggle top border Add or remove the border on the top of selected cells. | Alt T | ⌘ Option ▲ |
| Remove all borders This shortcut is a quick and easy way to get rid of all borders currently active on your selected cells. | Ctrl Shift _ | ⌘ Option _ |