How to Increase Border Size in Excel: Line Weight Guide

To increase border size in Excel, select the cells, choose a thicker line style, then apply it to the edge or edges you want. In Microsoft Excel for Microsoft 365 on Windows, use Home > Borders > Line Style, or open Format Cells with Ctrl+1 and set the style on the Border tab. Here, border size means line thickness, not row height, column width, or cell size.

What You’ll Need

An Excel workbook and the worksheet containing the cells you want to format.
A clear idea of which cell edges should be emphasized, such as the outside edge of a table, a bottom edge under headings, or all grid edges.
Excel for Microsoft 365 on Windows for the steps below. Excel for Mac and Excel for the web have similar border controls, but their menus may be arranged differently.

Step-by-Step

Select the target cells. Click a single cell, or drag across a range. To select a complete table, select only the cells that need the thicker border; applying formatting to a large range can make a sheet look crowded. For separate, nonadjacent ranges in Windows, hold Ctrl as you select each range. On a Mac, hold Command. If you want to outline a table, include all of its cells in the selection, including the header row.
Open the border controls. Go to the Home tab. In the Font group, find the Borders button, shown as a small square grid. Click the arrow beside it to open the menu. Clicking the main part of the button may repeat the last-used border command, so use the arrow when you want to choose a different line style or border placement.
Choose a heavier line style. In the Borders menu, point to Line Style and select a visibly thicker solid line. The available choices can vary slightly with Excel’s interface and display scale. A medium or thick solid line works well for a table outline; a thin solid line is usually easier to read for internal cell divisions. You can also choose Line Color from the same menu if the border needs a color, but color does not make a line physically thicker.
Apply the selected style to the intended edges. Open the Borders menu again and choose the appropriate placement, such as Outside Borders, Bottom Border, or All Borders. For a simple table outline, Outside Borders puts a frame around the selection without adding lines between every cell. Choose All Borders when you want the heavier line on each cell boundary as well. The command applies the currently selected border style.
Check the result and add individual edges if needed. Look at the selected range and confirm that the thickness appears on the correct sides. To add a different edge, choose the line style for that edge first, then select the relevant border command. For example, select a heading row and apply a thick Bottom Border to separate it from the rows below. If you apply a new style to an edge that already has a border, the new formatting replaces that edge’s previous style.
Use Format Cells when you need precise control. Select the range and press Ctrl+1 to open Format Cells. Select the Border tab. In the Line section, choose the desired line style; optionally choose a color. Then click the border positions in the preview, or select a preset such as Outline or Inside. Click OK to apply the changes. Make sure you click the preview edges after choosing the line style: selecting a style alone does not add a border.
Review the border at normal viewing size. Click another cell to see the finished formatting without the selection highlight. If the result is too heavy, select the affected cells and reapply a thinner line style to those edges. If you are preparing the sheet for printing, use File > Print to check the print preview as well; a line can look different on paper or at a different zoom level.

On Excel for Mac, select the cells and use Home > Borders to choose border placement and available line styles. For the dialog method, open Format Cells using Command+1, then use its Border tab. On Excel for the web, use Home > Borders and look for the available line-style options. The web version may not expose every desktop control; if you cannot choose the thickness you need, select Open in Desktop App and apply it there.

Common Mistakes

Changing cell dimensions instead of line thickness. Increasing row height or column width adds space around cell contents but does not make the border line heavier. Use the Borders controls to change line weight.
Choosing a line style without applying it. In the Format Cells dialog, selecting a thick line in the Line section only sets the style for the border you are about to add or edit. Click the desired edge in the preview before selecting OK.
Applying the wrong border placement. Outside Borders emphasizes the perimeter, while All Borders adds lines between cells too. If you only need a frame, All Borders can make the table look excessively busy. If only one side needs emphasis, use a command such as Top Border or Bottom Border instead.
Assuming the Borders button applies the menu choice automatically. The main button can repeat the previous border action. Use the dropdown arrow to inspect or change the style and placement, then apply the command you actually want.
Expecting a thicker line to change the worksheet gridlines. Gridlines are the faint guides shown across cells by default; they are separate from cell borders. To create a visible, printable heavy line, apply a border. Hiding gridlines does not remove borders you have added.
Formatting too large a range. A thick border around every cell in a large selection can overwhelm the data. Select just the table or section you mean to emphasize, and use a heavier outside edge with lighter internal lines when that is easier to scan.

Tips

Use a visual hierarchy. Reserve the thickest style for a table perimeter, total row, or major section break. Use thin lines for routine cell divisions. Consistent weights help readers understand the layout without competing with the values.
Apply an outline without changing internal lines. Select the full range, choose the heavier style, and apply Outside Borders. This is often the cleanest way to make a table stand out while leaving its internal formatting alone.
Format the header and total separately. A thick bottom border below the header or above a total can draw attention without surrounding every cell with heavy lines. Select only the relevant row or range before applying the edge.
Choose a color only when it improves contrast. A dark border on a light background is usually easy to read. If you use a colored border, check that it remains distinguishable when printed in grayscale and does not conflict with existing cell fill colors.
Test the print layout. Border thickness can look different on screen and on paper. Check File > Print, the paper size, and scaling before printing a large worksheet. If the line is too subtle in the preview, return to the sheet and choose a heavier style.
Use Format Painter for repeated formatting. If you need to copy the same border treatment to another range, select a cell or range with the finished formatting, click Home > Format Painter, then drag over the destination cells. Check the destination afterward, because Format Painter copies other cell formatting too, including number formats, fills, and fonts.
Keep borders distinct from table styles. If the range is an Excel table with a built-in style, that style may already supply lines or shading. You can still format individual borders, but check the table appearance after applying them. A table style and manually applied borders can combine in ways that look heavier than expected.

Troubleshooting

The border appears unchanged. Confirm that you selected the cells that actually have the edge you intend to format. Reopen the Borders menu, choose a thicker Line Style, and apply the placement again. If using Format Cells, make sure the border position is selected in the preview before clicking OK.
Only some sides became thicker. The command may have applied a style to only the selected border position. Select the range again and apply Outside Borders or All Borders as appropriate. For a custom combination, set each side individually in Format Cells.
The border looks dotted or different from expected. Reopen Line Style and choose a solid option rather than a dashed or dotted option. Also check Line Color; a pale color can make a thick line appear faint.
The border seems to disappear when you click away. A selected cell or range can make it difficult to distinguish border formatting from selection shading. Click an unused cell, then inspect the edge at a normal zoom. If necessary, check the range in Print Preview.
There is no Line Style option in the menu. The ribbon may be narrow, the menu may be presented differently, or the web version may not provide the full set of controls. Maximize the Excel window, open Format Cells, or use the desktop app. In the dialog, choose a style and explicitly select the border positions to apply it.
Printing does not match the worksheet view. Check Print Preview and verify that you are printing the intended sheet and range. Scaling a worksheet to fit a page can make borders appear smaller. Try a different scaling option or page orientation, and consider a heavier line style if it remains legible on the printed page.

Frequently Asked Questions

Can I make a border thicker than the choices in the menu?
Excel offers a set of built-in line styles rather than a field where you can enter an exact point size. Choose the heaviest available solid style. If you need more visual emphasis, use a contrasting line color as well, while keeping the sheet readable.

How do I thicken only the outside border of a group of cells?
Select the full range, choose a thick style from Home > Borders > Line Style, then choose Outside Borders. Avoid All Borders if you want the internal cell edges to remain unchanged.

How do I make just the bottom border thicker?
Select the cell or range, choose the desired line style, and apply Bottom Border from the Borders menu. In Format Cells, choose the style and click the bottom edge in the preview before clicking OK.

Can I increase the thickness of worksheet gridlines?
No. Excel’s default gridlines are display guides, not individually formatted cell borders, and their thickness cannot be set like a border. Apply cell borders to the range instead; they can be formatted and will print.

Will changing a border affect the cell’s value or formula?
No. Border formatting changes the cell’s appearance, not its contents or calculations. You can change, replace, or remove a border without editing the value in the cell.

How can I remove a thick border if I do not like it?
Select the affected cells, open Home > Borders, and choose No Border to remove all borders from the selection. To preserve other edges, use Format Cells > Border and clear only the positions you want to remove in the preview.

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.