How to Change Border Width in Excel: A Step-by-Step Guide

How-to basics · Updated November 20, 2026

To change a cell border’s width in Excel for Microsoft 365 on Windows, select the cells, open Format Cells with Ctrl+1, choose the Border tab, pick a line style, and apply it to the desired edges. Excel offers preset border weights rather than a box for entering a custom width in points or pixels. The thicker line can make a heading, total, or section stand out, while lighter lines help organize a table without overwhelming its contents.

What You’ll Need

  • An Excel workbook and the cells whose borders you want to change.
  • A general idea of which edges need a different line style, such as the outside edge, internal dividers, or one specific side.
  • Optional: a border color choice. If you do not choose one, Excel uses the color shown as the current selection in the Border tab.

It helps to distinguish borders from gridlines before you begin. Borders are formatting applied to cells and can be printed. Gridlines are the faint worksheet guides controlled separately; changing border style does not change the gridlines.

Step-by-Step

  1. Select the cells. Click a cell or drag across a range. To format a whole row or column, click its row number or column letter. For a non-adjacent selection on Windows, hold Ctrl while selecting additional ranges. Choose only the cells that should receive the new border; selecting a larger area can add lines where you do not want them.
  2. Open the border controls. Press Ctrl+1 to open the Format Cells dialog, then click the Border tab. You can also open it from Home > Font dialog box launcher (the small arrow in the lower-right corner of the Font group) and select Border. The dialog provides more control than choosing a basic border from the ribbon.
  3. Choose a line style. In the Style area, click the sample that matches the weight you want. Excel’s choices include thin, medium, and thick solid lines, along with dotted, dashed, and double styles. The exact samples are shown visually, so compare them in the dialog rather than assuming that every style is simply a different thickness. Excel does not provide a field for typing a custom width.
  4. Set the border color if needed. Open the Color menu in the Border tab and select a color before applying the border. Choose Automatic for the standard automatic color, or select a theme or standard color. If you want a colored line, pick the color first; then apply the edges in the next step. A color change applies to the border edges you add or change, not to the cell fill.
  5. Apply the style to the right edges. Use the Presets buttons, such as Outline or Inside, for common layouts. Outline applies a border around the outside of the selected range; Inside applies dividers between cells in the range. To control individual sides, click the corresponding edge in the preview diagram, or use the small border-edge buttons around it. For example, click the bottom edge to add a line beneath a selected heading. The preview shows which edges are selected.
  6. Confirm the change. Click OK to return to the worksheet. Look at the selected cells and check that the intended sides have the new appearance. If the result is wrong, reopen Format Cells and adjust the edges, or use Undo immediately with Ctrl+Z.
  7. Review the range at normal viewing size. Zoom out or scroll to check that the line separates the intended sections and does not make the table look crowded. If you are preparing a printout, use File > Print to check the preview. A border may appear stronger or weaker on screen depending on zoom, so judge it in the printed page layout as well.

For example, to give a monthly total row a strong bottom edge, select the total-row cells, open Format Cells > Border, choose a thick solid style, and click the bottom edge in the preview. If you want the whole total row framed, use Outline instead. This applies formatting to the selected cells; it does not change the widths of the columns or rows.

On a Mac, select the cells and press Command+1 to open Format Cells, then use the Border tab. The dialog layout and shortcut labels can vary slightly by Excel release, but the same basic process applies: choose a line style, select the edges, and confirm. In Excel for the web, use Home > Borders to access the available border options. The web interface may not expose every desktop dialog control, so use the Windows or Mac desktop app if you need the full set of style choices.

Common Mistakes

  • Looking for a numeric width box. Excel’s regular cell formatting offers preset border styles, not a custom width measurement. Choose the closest built-in weight. If the goal is a precise line in a report or drawing, a cell border may not be the right tool.
  • Changing gridlines instead of borders. Gridlines are worksheet guides; they are not cell borders and may not print. Apply a border through Format Cells > Border when you need a line that travels with the cells and appears in print.
  • Applying a style to the wrong area. When a range is selected, Inside can place lines between its cells, while Outline affects its perimeter. Selecting an entire column or large block may create many extra edges. Check the selection before clicking OK.
  • Forgetting which edges are selected. Picking a thick style alone does not necessarily change every existing edge. Use the preview or the appropriate preset to apply the style. If only one side changes, return to the dialog and explicitly select the other sides you intend to format.
  • Accidentally changing the border color. A colored line can look like a width problem, especially on a white sheet. Check the Color menu as well as the Style samples. Selecting Automatic or the intended color can restore a consistent appearance.
  • Expecting a border style to resize cells. Border formatting changes the cell edge, not row height, column width, or text size. Adjust those separately if the content is cramped.

Tips

  • Use weight to show hierarchy. A medium or thick outside border can frame a summary, while thin internal lines keep the data readable. Reserving the heaviest style for a few key areas makes it more useful.
  • Keep related tables consistent. Reuse the same line style and color for comparable headings or totals. A consistent scheme makes it easier to scan a workbook than giving every section a different border.
  • Format a whole range at once. If all cells in a small table need the same outside edge, select the complete range and use Outline. For internal separators, select the range and use Inside. Inspect the preview because these presets affect different edges.
  • Use the ribbon for common borders. Home > Borders offers quick choices for familiar cases such as bottom borders and outside borders. Use Format Cells when you need to choose a particular weight, color, or combination of edges.
  • Check print appearance. For printed worksheets, use File > Print to inspect how the border looks on the page. A line that appears subtle at one screen zoom may dominate a small printed table, or a very light line may be hard to see.
  • Save a clean version first. Border formatting is reversible with Undo, but if you are applying changes across a large worksheet, save the workbook before making broad edits. That gives you a straightforward recovery option if the result is difficult to restore.

Troubleshooting

The line still looks thin. Confirm that you selected a thicker sample in the Border tab and then clicked the correct edge or preset. Selecting a style is only part of the process; it must be applied to an edge. Also inspect at a different zoom level and in Print Preview, since screen scaling affects how a line looks.

Only the outside edge changed. That is expected if you chose Outline. To format dividers between cells, select the range again, choose the desired style, and apply Inside. To alter only one internal line, select the cells on either side of that boundary as appropriate and use the preview controls to apply the specific edge. Be careful with larger ranges, where an Inside preset affects all internal divisions.

The border appears on the wrong side or in the wrong place. Reopen Format Cells > Border and examine the preview before confirming. The preview corresponds to the selected cells, so a bottom edge appears at the bottom of each selected cell or range boundary. If a range contains merged cells, border behavior can be less intuitive; check the merged area and select its full extent before applying the edge.

The border does not show on screen. Check that the intended cells are selected and that you clicked OK. Make sure the color is not the same as the background, and verify that you applied a border rather than relying on gridlines. If the sheet is protected, formatting may be restricted; use Review > Unprotect Sheet if you have permission and the password, then make the change.

The selected style seems to affect a different color or edge. The Border tab stores a current style and color for the edges you apply. Reopen the dialog, choose the required color and style, then use the preview to make the target edges explicit. If the range already has mixed border formatting, reapplying the desired settings edge by edge is often more predictable than trying to change every existing line at once.

Frequently Asked Questions

Can I enter an exact border width in Excel?

No. Standard cell formatting provides preset line styles rather than a numeric width field. Choose the closest available weight, such as medium or thick. The actual appearance can vary with display zoom and printing.

How do I make only the bottom border thicker?

Select the relevant cells, open Format Cells with Ctrl+1, choose the Border tab, select a thicker style, and click the bottom edge in the preview. Click OK. On Mac, use Command+1 to open the formatting dialog.

Can I change the border width without changing its color?

Yes, but check the Color setting before applying the new style. Choose the existing or intended color, then apply the new line style to the needed edges. This helps avoid unintentionally replacing a colored border with Automatic.

Why do my borders disappear when I clear formatting?

Cell borders are formatting, so commands that clear cell formatting can remove them along with font, fill, and other styles. To remove only a border, use Format Cells > Border and choose None, or use the border removal option on the Home tab instead of clearing all formatting.

Will a thicker border print?

Yes. Cell borders are formatting and normally print with the worksheet, unlike screen gridlines, which may need separate print settings. Check File > Print to confirm the line is visible and appropriately weighted on the page.

Can I copy a border style to other cells?

Yes. Use Home > Format Painter to copy formatting from a cell or range to another area. It can copy more than borders, including font and fill formatting, so use it when those copied attributes are also wanted. For border-only changes, apply the border directly through Format Cells.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.