Draw your borders with the mouse

Don't waste your time to draw the border line of your table in Excel. The draw borders tool will help you to save a lot of time like in this example.

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

Menu Border in Excel

Draw the outline border

To draw easily the outline border of your data

  • Activate the tool Draw border (the cursor changes)
  • Drag & Drop to draw the border
Draw the outline border with the mouse

Draw the grid border

To draw the grid of your data

  • Activate the tool Draw border grid (the cursor changes)
  • Drag & Drop to draw the border
Option to draw the grid of your data

Draw a single line

To draw a single line,

  • Choose one of the options to draw borders
  • Follow the intersection between column or row
Draw a single line with the option draw border

Related posts


Permanent link to this article: https://www.excel-exercise.com/draw-your-borders-with-the-mouse/

1 comment

    • Al-amin on 12/06/2020 at 00:39
    • Reply

    hello there,
    that really nice keep the good work....

Leave a Reply

Your email address will not be published.