How to add all borders to cells with shortcuts in Excel?

As you know, borders are not added for cells in Excel by default. Sometimes, you may want to apply borders to cells to make them outstanding. Here I will introduce some shortcuts to add or remove all borders, as well as the Border command to apply borders in Excel.

Add or remove all borders with shortcuts in Excel

Add all outside borders with shortcuts of Ctrl + Shift + &: Select the cells you want to add all outside borders, and then press theCtrl + Shift + & keys at the same time, now you will see the outside borders are added for selected cells immediately.

Add all borders with shortcut of Alt – H – B – A: Select the range you want to add all borders, and then press Alt, H, B, A keys one by one. See screenshot:

Remove all borders with shortcuts of Ctrl + Shift + _: Select the range you want to clear all borders, and press the Ctrl + Shift + _ keys simultaneously, then you will see all borders are removed from selected range.

Add all borders to cells with Border command in Excel

In addition to hotkeys, we can also apply the Border command to add all borders to selected cells easily in Excel.

1. Select the cells you want to add all borders in Excel.

2. Go to the Home tab, and then click the Border > All Borders. See screen shot:Then you will see all borders are added to selected cells at once.

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...