A blog about Excel and its users
Applying borders to specific sides of a cell can be a very easy way to spruce up an area of an Excel spreadsheet. Borders help separate cells from each other, making it easier to differentiate one from another.
Perhaps the greatest function of borders is that they show up when you print your Excel spreadsheet, something the grid lines don’t do by default.
To get started select a cell, or a range of cells, which you want to apply a border to.
The shortcuts below are side specific, meaning you can only apply a border to 1 side at a time.
For this example I am applying a border to the bottom of the selected cells.
Next I am going to apply another border to the right of the cells to effectively block them off.
Let’s get even fancier - let’s extend both borders one cell and sum them all up:
If you ever want to remove a border you can execute the shortcut to apply a border to that specific side and it will be removed, or you can execute the Remove Borders shortcut to remove any border touching the cell.
The Remove Borders shortcut is:
And there you have it, the simplicity, and complexity, of borders in Microsoft Excel for Mac.XXXXX