sodcalculator

10 Tech How-To

Excel Border Ribbon Presets: Step-by-Step Guide

Guide 10-45083 · Updated · Step by step

This guide shows you how to apply borders to cells in Excel using the built-in ribbon presets, saving you from manually drawing each line. You’ll learn where the presets are, how to choose the right one, and how to customize them for a polished look. No prior Excel experience is needed—just a spreadsheet with some data.

What You’ll Need

  • Microsoft Excel (2010 or later, including Microsoft 365).
  • A worksheet with cells you want to border.
  • Basic familiarity with selecting cells (clicking and dragging).

Step-by-Step

  1. Select the cells you want to border. Click and drag over a range, or hold Ctrl to select multiple separate ranges.
  2. Go to the Home tab on the ribbon at the top of Excel. It’s the default tab, so you’re likely already there.
  3. Find the Borders button in the Font group. It looks like a square divided into four smaller squares. Next to it is a small dropdown arrow.
  4. Click the dropdown arrow (not the button itself) to open the Borders menu. You’ll see a gallery of preset border styles.
  5. Choose a preset from the menu. For example:
    • Bottom Border – adds a line under each selected cell.
    • Top Border – adds a line above each selected cell.
    • Left/Right Border – adds lines on the sides.
    • All Borders – adds a border around every cell in the selection.
    • Outside Borders – adds a border only around the outer edge of the selection.
    • Thick Outside Borders – same as outside, but with a thicker line.
    • Top and Bottom Border – lines above and below, but not between rows.
    • No Border – removes all borders from the selection.
  6. Click the preset and the border is applied immediately. If you want to remove it, select the same cells and choose “No Border” from the menu.
  7. To reapply the same border to another selection, just select the new cells and click the Borders button itself (not the dropdown). Excel remembers your last used border style.
  8. For more options, click “More Borders…” at the bottom of the dropdown. This opens the Format Cells dialog with a Border tab where you can choose line style, color, and individual borders.

Common Mistakes

  • Selecting the wrong range: If you select entire rows or columns, borders may appear in unexpected places. Double-check your selection before applying.
  • Using “All Borders” when you want only outside: “All Borders” puts lines between every cell, which can look cluttered. For a clean table with just an outer box, use “Outside Borders.”
  • Clicking the Borders button instead of the arrow: This applies the last used border, which might not be what you want. Always use the arrow to see the menu.
  • Forgetting that borders are part of cell formatting: Copying and pasting cells can bring along borders you didn’t intend. Use “Paste Special” and choose “Values” to avoid this.

Tips

  • Use keyboard shortcuts: Press Alt+H, then B, to open the Borders menu quickly without touching the mouse.
  • Create a custom border style: In the “More Borders…” dialog, you can set a specific line style (dashed, dotted, double) and color, then save it as a custom style for future use.
  • Apply borders to a whole table: Select the data range (including headers), then use “All Borders” for a classic spreadsheet look. Add a thick outside border to emphasize the table.
  • Use the Format Painter: After applying a border to one range, click the Format Painter icon (paintbrush) in the Clipboard group, then click another range to copy the border formatting instantly.
  • Print borders: If borders don’t show up when printing, check the print preview. Sometimes you need to set the print area or adjust page setup to include gridlines.

Troubleshooting

  • Borders not showing: First, check that the cells are selected. If they are, look at the border color—if it’s white, it may be invisible on a white background. Go to “More Borders…” and choose a darker color. Also, ensure the worksheet is not in “Page Layout” view with gridlines hidden.
  • Borders disappear when printing: In the Ribbon, go to Page Layout > Sheet Options and check “Print” under Gridlines. If you’re using borders, they should print, but if not, try selecting the range and using “Print Area” to set it.
  • Borders apply to wrong cells: This usually happens when you have merged cells. Borders on merged cells can behave oddly. Unmerge the cells, apply borders, then remerge if needed.
  • Can’t find the Borders button: If the Home tab is not visible, you may have the ribbon collapsed. Double-click any tab to expand it. The Borders button is in the Font group, which is the second group from the left.
  • Border style not sticking: If you choose a style in “More Borders” but it doesn’t apply, make sure you click the “Outline” or “Inside” buttons in that dialog before clicking OK. Otherwise, the style is set but not applied to the selected area.

Frequently Asked Questions

How do I remove all borders from a range?

Select the range, open the Borders dropdown, and choose “No Border.” This removes all borders from the selection.

Can I apply borders to only the outside of a selection?

Yes, use the “Outside Borders” preset. For a thicker line, choose “Thick Outside Borders.”

How do I change the border color?

Click the dropdown arrow next to the Borders button, select “Line Color” at the bottom, pick a color, then use the Borders button to apply it. Or go to “More Borders…” and choose a color there.

Why do my borders not print?

Ensure that the borders are applied to the cells and that the print area includes them. Also check the print preview; if gridlines are missing, go to Page Layout > Sheet Options and check “Print” under Gridlines.

Can I save a custom border style for reuse?

Yes, in the “More Borders…” dialog, set your desired style, then click “OK.” The next time you open the dialog, your custom style will be there. However, it won’t appear in the quick dropdown, only in the full dialog.

What is the difference between “All Borders” and “Outside Borders”?

“All Borders” puts a border around every cell in the selection, including internal lines. “Outside Borders” only puts a border around the outer edge of the entire selection.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →