How to Add Border in MS Excel

Borders transform a wall of numbers into something people can actually read.

Without them, your data blurs together — no structure, no hierarchy, no clarity. With the right borders, a spreadsheet becomes a professional report that communicates instantly.

Whether you’re building a budget tracker, a project timeline, or a sales report, mastering Excel borders takes less than five minutes. This guide covers every method — from the fastest keyboard shortcut to the most precise cell-formatting options.

Let’s get your spreadsheet looking exactly the way it should.

Why Borders Matter More Than You Think

Most people treat Excel borders as decoration. They’re not.

Borders serve a functional purpose: they guide the eye, separate sections, and make data scannable at a glance. Research consistently shows that structured layouts reduce reading time and improve decision-making speed — and that applies to any data environment, not just executive dashboards.

A well-bordered spreadsheet also looks more credible. When you share a report with borders versus one without, the difference in perceived professionalism is immediate.

Now — here’s exactly how to apply them.

How to Add a Border Using the Home Tab Ribbon

This is the fastest method for most situations and works in all Excel versions.

Step 1: Select the cell or range of cells where you want to add a border.

Step 2: Go to the Home tab on the top ribbon.

Step 3: In the Font group, find the Borders button (it looks like a square divided into four). Click the dropdown arrow next to it.

Step 4: Choose your preferred border style from the list:

• All Borders — applies borders to every side of every selected cell
• Outside Borders — applies a border only around the outer edge of your selection
• Thick Box Border — applies a bold outer border for emphasis
• Bottom Border — applies a border only to the bottom of the selected cells
• Top and Bottom Border — commonly used for header rows

Step 5: The border applies instantly. No extra confirmation needed.

This method gives you the most common border options in the fewest clicks. For custom styles (dashes, colors, double lines), keep reading.

How to Add a Border Using a Keyboard Shortcut

If you live in the keyboard, this is your move.

Select your target cells, then press:

• Ctrl + Shift + & — applies an outline (outside) border to the selection
• Ctrl + Shift + _ — removes all borders from the selection (underscore key)

These two shortcuts handle 80% of everyday border needs. They don’t give you style control, but for speed, nothing beats them.

Pro tip: Combine with Ctrl + A to select the entire used range before applying — instant full-sheet border in two keystrokes.

How to Add a Custom Border Using Format Cells

For full control over style, color, thickness, and specific sides, the Format Cells dialog is where you go.

Step 1: Select your target cells.

Step 2: Press Ctrl + 1 to open the Format Cells dialog box (or right-click → Format Cells).

Step 3: Click the Border tab.

Step 4: In the Style section, choose a line style — solid, dashed, dotted, double line, and more.

Step 5: In the Color section, pick any border color using the dropdown.

Step 6: In the preview area (the box on the right), click on the specific sides where you want borders to appear:

• Click the edge buttons to toggle individual sides (top, bottom, left, right)
• Click the diagonal buttons to add diagonal lines inside a cell
• Click Outline for a quick outer border
• Click Inside to apply interior borders within a multi-cell selection

Step 7: Click OK to apply.

This method is the gold standard when you need precise, styled borders — for example, a thick outer border with thin inner lines, or a red bottom border to flag a threshold row.

How to Draw Borders Manually

Excel’s Draw Border tool lets you paint borders directly onto cells, like a brush.

Step 1: Go to Home → Borders dropdown → Draw Border (or Draw Border Grid).

Step 2: Your cursor changes to a pencil icon.

Step 3: Click and drag across the cells to draw border lines exactly where you want them.

Step 4: Use Draw Border for outer edges, and Draw Border Grid to fill in all internal lines at once.

Step 5: When done, press Escape to exit drawing mode.

This mode is useful when you want non-rectangular border layouts — for example, applying borders only to every other column without selecting complex ranges.

How to Add Borders to Specific Cell Sides Only

Sometimes you only need a bottom border under a header row, or a left border to create a sidebar effect. Here’s how to do it precisely:

Option A — Via the Ribbon Dropdown: Select your cells → Home → Borders dropdown → choose “Bottom Border,” “Top Border,” “Left Border,” or “Right Border” directly.

Option B — Via Format Cells: Ctrl + 1 → Border tab → click only the specific side(s) you want in the preview diagram → OK.

Option C — Via Keyboard: There’s no dedicated shortcut for individual sides, but using the Format Cells dialog (Ctrl + 1) is nearly as fast.

Common use cases:

• Bottom border only under column headers for a table-style look
• Left border on the first column to create a visual margin
• Top + Bottom borders to highlight a totals row without closing off the column

How to Change Border Color and Thickness

Color and thickness turn a functional border into a visual system.

To change border color: Home → Borders dropdown → Line Color → pick your color, then click the cells to apply.

Or use Format Cells (Ctrl + 1) → Border tab → Color dropdown → apply.

To change border thickness: Format Cells → Border tab → Style section → select a thicker line style → apply to the sides you need.

Recommended combinations for professional spreadsheets:

• Dark gray outer border + light gray inner borders — clean, modern look
• Thick black outer + thin inner — classic reporting style
• Color-coded borders — use brand colors on summary rows for fast visual navigation

How to Remove Borders in Excel

Removing borders is as simple as adding them.

Method 1 — Keyboard: Select cells → Ctrl + Shift + _ (underscore) — removes all borders instantly.

Method 2 — Ribbon: Select cells → Home → Borders dropdown → No Border.

Method 3 — Format Cells: Ctrl + 1 → Border tab → click None preset → OK.

To remove borders from the entire sheet at once: press Ctrl + A to select all, then apply any of the three methods above.

Common Excel Border Mistakes to Avoid

Even experienced users make these errors:

Mistake — Applying borders before merging cells. Merged cells reset border settings. Always merge first, then apply borders.

Mistake — Using borders instead of table formatting. Excel’s built-in Table feature (Ctrl + T) handles borders automatically and updates dynamically as you add rows. For growing datasets, use tables instead of manual borders.

Mistake — Inconsistent line styles across sections. Mixing heavy, light, dashed, and solid borders without intention looks chaotic. Pick two line weights and use them consistently.

Mistake — Printing without checking borders. Screen borders don’t always match print output. Always preview (Ctrl + P) before finalizing a document.

Quick Reference: Border Methods at a Glance

Conclusion

Excel borders are one of those features that seem simple but have a surprising amount of depth. The ribbon method handles most everyday needs in three clicks. The Format Cells dialog gives you complete control when precision matters. And keyboard shortcuts keep your hands where they belong — on the data.

Start with the method that matches your pace. Once you’ve built the muscle memory, bordered spreadsheets will stop looking like extra work and start feeling like second nature.

The goal was never beautiful formatting for its own sake — it was making your data communicate faster and more clearly. Borders are how you do that.