Did you know that you can draw borders in Excel using just your mouse? This method offers greater precision and can significantly save you time in your daily tasks.

Do you know the Draw Borders tool?

In Excel, you can easily draw your data’s border or grid 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.

To wrap up, now that you know how to draw borders in Excel with just your mouse, you’re equipped with a handy trick that can make your spreadsheet work a breeze! This simple technique not only adds precision to your designs but also frees up more time for the fun stuff. Happy border-drawing and enjoy the extra time saved for those daily joys!

Related articles

• Remove Gridlines in Excel Easily
• Tutorial – Number Format in Excel
• Tutorial – Excel Alignment text tips
• All Excel tricks to Copy-Paste
• Tutorial – Tricks to Copy and Delete Rows and Columns
• Tutorial – Moving or Swapping rows and columns