Look Who it Was Random video

Excel - How to Draw Borders in Excel (Color, Style, Thickness) - Episode 1246

1,790 views · Published 16 September 2010 · 1:54 · Indexed 26 September 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel in Depth: How to Draw Borders in Excel | MrExcel Podcast.

Welcome back to the MrExcel podcast. In this episode, we will be diving into chapter 30 of Excel in Depth, where we will be discussing the draw borders feature. This tool was present in Excel 2003 but disappeared in later versions, only to make a comeback in Excel 2010. Join me, Bill Jelen, as we explore the various functions and capabilities of this useful tool.

To access the draw borders feature, simply click on the drop-down menu on the home tab. However, I prefer to have this tool readily available on my quick access toolbar for easier access. In this drop-down, you will find five new tools that allow you to choose a line style and color. Once you select either one, you will automatically enter "Draw a Border" mode, indicated by the appearance of dots and a pencil.

There are two modes within the draw borders feature - draw a border and draw a border grid. When drawing a border, you can simply click on the border to add a single line. If you want to draw a range, you can click and drag to create a box around the selected cells. You can also change the line color by selecting a different color from the drop-down. On the other hand, draw border grid is a great way to quickly fill in a grid by selecting the starting and ending points.

While there are many settings available in the border drop-down, I often find myself heading straight to "More Borders" to achieve the desired result. However, with these new tools, you can easily erase, draw a grid, or draw borders without having to leave the drop-down menu. This is a clever feature that allows you to achieve the same results as the traditional dialog box, but with a more streamlined approach.

Thank you for tuning in to this episode of the MrExcel podcast. I hope you found this tutorial on the draw borders feature helpful. Don't forget to join us next time for another netcast, where we will be exploring more Excel tips and tricks. See you soon!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents
(00:00) How to Draw Borders in Excel
(00:16) Borders Drop-Down on Home tab
(00:36) Draw Border offers two modes
(01:00) Changing line color
(01:12) Filling a range with borders
(01:22) More Borders dialog
(01:38) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelborders

This video answers these common search terms:
how to draw borders in excel
how to change color of borders in a table excel
excel how to add colored border to cell
how to make line borders in excel
how to format borders of cell in excel
how to quickly add borders in excel
excel how to erase borders
excel how to make borders
how to apply borders in excel
how to apply thick outside border excel
how to bold borders in excel youtube

The Border Drawing Tools are back in Excel 2010! Use the border drawing tools to quickly add borders to a cell or range of cells. Learn how to find and use them in Episode #1246, with MrExcel.

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1152927/

More from this channel