How to Add or Remove Cell Borders in Excel

Date:2019-10-21 Author:Cordelia

To add or remove cell borders in Excel, the quickest way is using shortcuts in your keyboad. Try following steps:

Add Cell Borders in Excel

1. Select the cell or the range of cells you want to add borders.

How to Add or Remove Cell Borders in Excel

2. Then press [Ctrl]+ [Shift] +[&] in your keyboard.

How to Add or Remove Cell Borders in Excel

3. Now you can see the borders have been added with black lines.

How to Add or Remove Cell Borders in Excel

Remove Cell Borders in Excel

1. If you don’t want cell borders anymore, first select the cell or the range of cells which have cell borders.

How to Add or Remove Cell Borders in Excel

2. Then press [Ctrl] + [Shift] + [-] in your keyborad. All cell boders will be removed in a second.

How to Add or Remove Cell Borders in Excel
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *