How to Change Border Thickness in Excel for Clearer Sheets

How-to basics · Updated November 20, 2026

To change border thickness in Excel for Microsoft 365 on Windows, select the cells, open Home > Borders using the arrow in the Font group, choose a weight under Line Style, then apply the border you want. For precise control over individual edges, use the Format Cells dialog. A thicker line makes key cells, totals, or sections easier to distinguish; it changes the cell border, not the worksheet gridlines.

What You’ll Need

  • An Excel workbook you can edit. If it contains important data, save a copy before changing its formatting.
  • The cells or range whose borders you want to change. You can select one cell, a group of cells, or an entire table range.
  • Excel for Microsoft 365 on Windows for the menu paths below. Excel for Mac has similar border controls, with some keyboard shortcuts differing. Excel for the web may offer fewer line-style choices; open the workbook in the desktop app if you cannot find the weight you need.

Step-by-Step

  1. Select the cells to format. Click a cell, or drag across a range. To select a row or column, click its row number or column letter. For a table, select the cells where the border should appear rather than assuming that selecting the table object will target the exact edges you want. You can select multiple nonadjacent ranges by holding Ctrl while selecting each one on Windows.
  2. Open the border controls. Go to the Home tab and find the Font group. Click the small arrow beside the Borders button, not the main button itself. The main button repeats the most recently used border command, while the arrow opens the menu of border options and line settings.
  3. Choose a line weight. In the Borders menu, point to or open Line Style, then choose the thickness and pattern you want. The choices typically include fine, medium, and heavy solid lines as well as some dashed or dotted styles. The sample line gives a rough visual guide; it is not a numeric measurement in points. If you need a clear but restrained result, start with a medium solid line and check how it looks at normal zoom.
  4. Apply the style to the intended edges. Open the Borders arrow again if the menu closed after choosing the style, then choose a border command such as Outside Borders, All Borders, or Bottom Border. Use Outside Borders for a frame around a range; use All Borders to add lines between cells as well as around the outside. For a custom layout, use the drawing commands in the menu, such as Draw Border, and click or drag along the cell edges you want to format. Avoid clicking inside a cell when drawing, because the border tool works on its edges.
  5. Check the result and apply other edges as needed. Look at the range at a practical zoom level. If you chose a heavy style and then used All Borders, the interior grid may look crowded. You can undo immediately with Ctrl+Z on Windows, or reopen the menu and apply a lighter style to the interior edges. You can also apply different weights to different sides by repeating the style selection and choosing one edge at a time.
  6. Use Format Cells for exact placement. Select the range and press Ctrl+1 on Windows to open Format Cells. Choose the Border tab. Under Style, click the desired line sample, then click the sides in the preview box to add or change those borders. The preview lets you set the top, bottom, left, right, and diagonal lines separately. Click OK when the preview matches your intended layout.
  7. Set a border color if needed. For a colored border, open the Borders menu and use Line Color before applying the border, or choose a color in the Border tab of Format Cells. Pick a color with enough contrast against the cell fill and text. Changing the color does not automatically change the weight, so choose both settings when you need a particular combination.
  8. Repeat only where necessary. If several ranges need the same treatment, select each range and apply the same style and border command. You can also copy formatting with the Format Painter on the Home tab: select a cell with the desired border, click Format Painter, then select the destination cells. Check the destination afterward, because Format Painter copies other formatting too, including number formats, font, and fill.

On a Mac: The border controls are also on the Home tab, in the Borders menu in the Font area; look for the line-style and border-placement options there. To open Format Cells, use Command+1 rather than Ctrl+1. On Excel for the web, check the Home tab’s Borders menu. If it does not show the line styles or detailed preview you need, use Open in Desktop App and make the change in Excel for Windows or Mac.

Common Mistakes

  • Choosing a border placement but not a heavier line. Outside Borders and All Borders describe where lines go, not how thick they are. Choose the line style first, then apply the placement.
  • Changing gridlines instead of cell borders. Worksheet gridlines are the faint guides that appear across cells without explicit formatting. The View tab’s Gridlines setting shows or hides them; it does not set their thickness. Use the Borders menu to create visible, printable cell borders.
  • Applying All Borders to a large range without checking the interior. This puts a line between every neighboring cell. A heavy weight can make a wide data block look like graph paper. Use Outside Borders for a simple outline, or apply medium interior rules and a heavier outline separately.
  • Formatting the wrong selection. A border command applies to the selected cells. If only one cell is selected, Excel will not frame the whole table. Confirm the selection outline before choosing the border command.
  • Expecting the line to look identical at every zoom or on every printer. Screen scaling, display resolution, and printer settings affect how borders appear. A very fine style may be hard to see on screen or in a printout, so use Print Preview for important sheets.
  • Using Format Painter when only the border should change. It copies more than borders. If the destination’s font or number format must stay as it is, apply the border directly instead.

Tips

  • Use weight to show hierarchy. A heavier outside border can identify a report section, while thinner interior lines keep the information readable. A medium bottom border works well beneath a header or above a total without boxing every cell.
  • Format totals consistently. Apply a heavier top border to the total row rather than relying on bold text alone. Select only the total cells, choose the line style, and apply a top border. This makes the separation clear without adding a line below every value.
  • Try the preview before confirming. In Format Cells, click line style and edge combinations in the preview before choosing OK. It is easier to spot an accidental double edge or diagonal line there than after applying formatting across a large range.
  • Keep contrast and restraint in mind. Thick borders are most useful when reserved for key divisions. For a dense worksheet, use a neutral color and limit heavy lines to outlines, headers, or totals. Too many strong borders compete with the data and make scanning harder.
  • Check the printed page. Choose File > Print to inspect the print preview. If the border looks too faint, try a stronger style or darker color. Page scaling can shrink the sheet, so a line that looks prominent at 100% zoom may print less visibly.
  • Keep the style consistent across related sheets. If multiple worksheets form one report, use the same border weight for the same purpose on each sheet. This makes headings and totals easier to recognize and avoids a patchwork appearance.

Troubleshooting

The border stays thin after choosing a heavier style. First confirm that you selected a line under Line Style, then apply a border command to the selected cells. Selecting a style alone may not change existing edges until you apply it. If needed, use Format Cells, select the weight, click the relevant edge in the preview, and choose OK.

The border appears only on some sides. The chosen command may affect only one edge, or the selection may not include the full range. Select the full intended range and use Outside Borders or All Borders as appropriate. For a custom layout, click each needed side in the Format Cells preview; the preview shows exactly which edges are active.

The menu has no useful weight options. Confirm that you opened the arrow beside Borders rather than clicking the main Borders button. If you are using Excel for the web and the controls are limited, open the file in the desktop app. If you are using the desktop app, Format Cells is another route to the line-style choices.

The border is difficult to see. Check that the border color contrasts with the cell fill, and distinguish it from worksheet gridlines. Zoom in briefly to inspect the edge, then check at normal zoom and in Print Preview. If the selected line is too heavy, use the menu to choose a finer style and reapply it to those edges.

The border does not print as expected. Use File > Print and inspect the preview. Check whether the range is being scaled to fit a page, whether a color is too light, and whether the printer is set to use color or grayscale. If the issue is only that the faint worksheet grid is missing, remember that gridlines and explicit cell borders are separate; add cell borders for reliable printed lines.

You changed formatting you did not intend to change. Press Ctrl+Z on Windows (Command+Z on Mac) promptly if the last action caused the issue. If several formatting actions have followed, select the affected cells and restore the needed border settings through Format Cells. For broader changes, use the Undo list carefully or reopen a saved copy rather than applying more formatting blindly.

Frequently Asked Questions

Can I enter a precise border thickness in points?
Excel’s standard cell-border controls offer preset line styles rather than a box for entering a custom numeric thickness. Choose the closest available weight in the Borders menu or Format Cells. These options are sufficient for most worksheet outlines and section dividers.

Can I make only the outside border thick?
Yes. Select the full range, choose the heavy line style, and apply Outside Borders. If the range already has interior lines, avoid All Borders when setting the heavy weight, or the interior lines may become heavy too. You can set a lighter interior style separately.

Can different sides of one cell have different thicknesses?
Yes. Open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, select the Border tab, choose a line style, then click the required sides individually in the preview. Choose another style and repeat for sides that need a different weight.

Does changing border thickness affect the whole worksheet?
No. Border formatting applies to the selected cells and the edges you choose. To format a whole sheet, select the entire sheet first, but consider whether adding borders everywhere will make the data harder to read.

Why do borders look different from gridlines?
Gridlines are worksheet guides controlled from the View tab and generally do not print unless configured separately. Borders are formatting applied to cell edges, can use different weights and colors, and are the better choice when you need reliable visual divisions or printed lines.

Will my border settings remain if I share the workbook?
Yes. Cell borders are part of the workbook formatting and normally remain when the file is saved and shared. The appearance can vary slightly with screen scaling, printer output, or software compatibility, so inspect a PDF or print preview if exact presentation matters.

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.