Excel is a good software for users to make a table, record data and so on. However, if we want to make our statistics more readable, it is important to use borders for your data. For convenience, I am going to tell you how to use shortcut keys to add or delete borders in excel.
How to use shortcut key to add an outline border in excel
Step 1:Drag the mouse and select the region you want to add an outline border to
Step 2:
(for MAC)Press ‘command’,’option’ and ‘0’ three keys at the same time. Then we will see an outline border circling the region that you have chosen before. The picture is shown as follows.
(for PC)Press ‘ctrl’,’ shift’ and ‘7’ three keys at the same time. Then we will see an outline border circling the region that you have chosen before. The picture is shown as follows
Now，you have learned how to use shortcut keys to add an outline border in excel.
How to use shortcut keys to add one side of border in excel
Step 1:Drag the mouse and select the region you want to add one side of border to, which is the same as the first step of adding an outline border.
Step 2:
(for MAC)Press ‘command’,’option’ and ‘↑/↓/←/→’ three keys at the same time. Then we will see a top/bottom/left/right border appear in the region you have chosen before. The picture is shown as follows. However, if you press these three keys at the same time again, the border will disappear.
(for PC)Press ‘Alt’,’ H’,’ B’ and ‘T/B/L/R’ three keys in turn. Then we will see a top/bottom/left/right border appear in the region you have chosen before. The picture is shown as follows. However, if you press these three keys in turn again, the border will disappear.
Now，you have learned how to use shortcut keys to add different side of border in excel.
How to use shortcut key to remove borders in excel
Step 1:Drag the mouse and select the region you want to remove the border to, which is the same as the first step of adding an outline border.
Step 2:
(for MAC)Press ‘command’,’option’ and ‘-‘ three keys at the same time. Then we will see the border circling the region that you have chosen before disappearing. The picture is shown as follows.
(for PC)Press ‘ctrl’,’ shift’ and ‘-‘ three keys in turn. Then we will see the border circling the region that you have chosen before disappearing.The picture is shown as follows.
Now，you have learned how to use shortcut keys to remove borders in excel.
Another method for borders in excel
If you can not remember which keys you need to press, you can also learn another method for border in excel. The method is shown as follows.
Step 1:Drag the mouse and select the region you want to add/remove the border to, which is the same as the first step of adding an outline border.
Step 2:Click the borders arrow, and then you will see a lot of choices for borders.
Step 3:Select the choice you want for borders.
Learn more about shortcut keys for border in Excel
If you are looking for the best tool for borders, then I recommend you to use the WPS Office suite, the shortcut key for borders in WPS is the same as excel. WPS Office is an Office Suite program like MS Office. It consists of four individual and unique program. Word,Excel,PPT,PDF.
In my opinion, WPS office is another alternative options to use shortcut keys for border in Excel.
WPS Office is also compatible with Microsoft Office files. You can open all your MS Office using WPS Office，Click it to free download now~
