Borders and Shading

Tips, Tricks, and Answers

The following articles are available for the 'Borders and Shading' topic. Click the article's title (shown in bold) to see the associated article.

Adding Borders to Cells
A few quick ways to add borders to a cell or range of cells.

Adding Diagonal Borders
Borders on all sides of a cell are easy to do in Excel. You can also create diagonal borders that run right through the middle of the cell.

Automatic Lines for Dividing Lists
You can use conditional formatting to add automatic dividing lines between groups of data in your worksheets. This tip shows how easy it is to add the lines.

Changing the Color of a Cell Border
Many people add borders to cells on a regular basis, yet have no clue that you can change the color of those borders. This tip shows how easy it is to get just the right hue for your cell borders.

Drawing Borders
Adding borders around cells is a common formatting task. You can make the task more intuitive by actually drawing the borders using the mouse.

Removing Borders
Want to quickly remove all the borders from a cell? There is no need to use the menus or display dialog boxes. Just use the handy shortcut provided in this tip.

Rounded Corners on Cells
As you are formatting a worksheet, Excel allows you to easily add borders to cells. Adding rounded corners to cells is a different story; there is no easy way to do it. This tip presents a workaround that may help you achieve the desired outcome.