The draw borders tool is your best friend to help you to save a lot of time for drawing your borders.

Do you know the Draw borders tool?

In Excel, you can easily draw the border or the grid of your data just with your mouse. But first you must activate one of these options in the ribbon Home

Draw the outline border

To draw easily the outline border of your data

1. Activate the tool Draw border (the cursor changes)
2. Drag & Drop to draw the border

Draw the grid border

To draw the grid of your data

1. Activate the tool Draw border grid (the cursor changes)
2. Drag & Drop to draw the border

Draw a single line

To draw a single line,

1. Choose one of the options to draw borders
2. Follow the intersection between column or row

Tutorial Video

Have a look at this video to see in action how you can draw your borders in no time