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
- Activate the tool Draw border (the cursor changes)
- Drag & Drop to draw the border
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
Draw a single line
To draw a single line,
- Choose one of the options to draw borders
- 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!
12/06/2020 @ 00:39
hello there,
that really nice keep the good work....