How to draw borders and border grids in Excel

Abstract

Excel provides another method for creating borders around cells.

Let’s take a look.

To draw a border, first select a color and a line style.

In draw border mode, you’re free to draw a border along any gridline.

We can use this flexibility to draw an irregular border.

Now let’s look at the second border drawing mode, Draw Border Grid.

In this mode, Excel will create both outside and inside borders at the same time.

When following a gridline, Draw Border Grid works like Draw Border, adding a single line.

To stop drawing borders, just poke the Border button on the ribbon.

This disables the current drawing mode.

This button remembers the last drawing mode used.

When you click it again, that mode will be re-enabled.

Now let’s look at how to erase borders.

First, select Erase Border.

It’s also possible to click and drag over cells to remove their borders.