How to apply Borders in Excel Using Shortcut
Excel Shortcut Keys to apply borders are listed below:
Shortcuts |
Descriptions |
---|---|
Alt + H + B |
To open a list of borders styles from ribbon |
Ctrl + Shift + & |
Add a border around selected cells |
Alt + H +B,R |
Add or remove the right border |
Alt + H, B, L |
Add or remove the left border |
Alt +H, B, P |
Add or remove the top border |
Alt + H, B, O |
Add or remove the bottom border |
Alt + H, B, A |
Add all borders to all cells in the selection |
Ctrl + Shift + – |
Remove borders |
Top 100+ Excel Shortcut Keys List (A to Z)
Did you know that using keyboard shortcuts can increase productivity and save you time? Although the term “shortcut” may seem intimidating, it’s important to consider the benefits if you use computers every day!
Here, we provide a list of all essential list of excel shortcut keys, Starting with Basic Excel Shortcuts to advanced Excel shortcut keys.
We have also compiled all the essential computer shortcut keys, which include shortcuts for popular software like Microsoft Word, Excel, PowerPoint, and Gmail, as well as special characters and shortcuts relevant to competitive exams.