Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to draw borders and border grids in Excel

How to draw borders and border grids in Excel

Transcript 

Excel provides another method for creating borders around cells. Instead of selecting cells first and then applying a border, you can, instead, select a border tool and draw borders directly on the worksheet.

Let's take a look.

Near the bottom of the border menu on the home tab of the ribbon is a group of commands for drawing borders. Excel has two basic modes for drawing borders: Draw Border and Draw Border Grid, and another mode for erasing borders called Erase Border.

To draw a border, first select a color and a line style. Notice that when we select either of these options, Excel shifts into draw border mode; the Draw Border menu item is selected, and the cursor changes into a pencil.

In draw border mode, you can draw a border along any gridline. We can use this flexibility to draw an irregular border. While this could be done in multiple steps, using the Format Cells dialog box, it would be tedious. With Draw Border enabled, you can also click and drag to create a rectangular border around any block of cells.

Now let's look at the second border drawing mode, Draw Border Grid. In this mode, Excel will create both outside and inside borders at the same time. When following a gridline, Draw Border Grid works like Draw Border, adding a single line. However, when you click and drag across cells, Draw Border Grid creates borders around all cells that are part of the selection.

To stop drawing borders, just click the Border button on the ribbon. This disables the current drawing mode. This button remembers the last drawing mode used. When you click it again, that mode will be re-enabled.

Now let's look at how to erase borders. First, select Erase Border. With this option selected, it's possible to remove borders one at a time by clicking each border individually. It's also possible to click and drag over cells to remove their borders.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Holy cow thank you Dave, your article "VLOOKUP with numbers and text" saved my butt. Many appreciations and happy friday!
Cameron
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page