To make a thicker bottom border in Excel, select the cells, go to the Home tab, click the arrow next to Borders in the Font group, and choose Thick Bottom Border. For a specific line weight or color, choose More Borders instead, pick a heavier line under Style, and click the bottom edge in the preview.
These steps are for Excel for Microsoft 365 on Windows and also match Excel 2024, 2021, 2019 and 2016. Excel for Mac and Excel for the web have their own sections below. The menu names come from Microsoft’s Apply or remove cell borders on a worksheet and Change the width of cell borders articles.
Use a Sheet You Can Edit
- A sheet you can edit. If the file opened in Protected View or as read-only, select Enable Editing first. A protected worksheet can also block formatting, which is covered under troubleshooting.
- Know what a border is. A border is a line drawn on the edge of a cell. It is different from gridlines, the faint guide lines Excel shows on screen, and different from Bold or Underline, which change the text, not the cell.
- Know the three solid weights. Excel offers a thin, a medium and a thick solid line. The Thick Bottom Border preset uses the thickest one. Microsoft notes that wider widths are only available for solid (continuous) lines, not dashed or dotted ones.
| Option | What it draws |
|---|---|
| Bottom Border | Thin line under the selection |
| Thick Bottom Border | Heaviest solid line under the selection |
| Bottom Double Border | Two thin lines, often used under a grand total |
| Top and Thick Bottom Border | Thin line on top, heavy line underneath |
| Outside Borders | Thin box around the whole selection |
How to Add a Thick Bottom Border From the Borders Menu
This is the fastest route and works for a single cell, a row of headings or a totals row.
- Select the cell or range. For example, drag across A1:F1 to select a row of column headings.
- On the Home tab, in the Font group, click the small arrow next to the Borders button. A list of border presets opens.
- Choose Thick Bottom Border. To add a thin line on top as well, choose Top and Thick Bottom Border.

- Click any empty cell to clear the selection highlight, then look at the bottom edge. You should see a heavy line under the cells you selected.
The Borders button now shows the style you just used. Click the button itself (not the arrow) to apply the same thick bottom border to other cells.
Use the keyboard instead
Excel for Windows uses KeyTips, the letters that appear on the ribbon when you press Alt. The sequence Alt+H, B opens the Borders menu. Press the keys one after another, not together:
- Select the cells.
- Press Alt, then H, then B. The Borders list opens with a letter next to each option.
- Press the letter shown next to Thick Bottom Border. In current versions of Excel for Windows this is H.
If a different letter appears on your screen, use the one Excel displays. Ctrl+B does not add a border; it makes the text bold. Ctrl+Shift+& adds a thin outline around the selection, not a thick bottom line.
How to Choose the Exact Weight and Color
The More Borders command opens the Format Cells dialog, where you control the line style, color and position separately.
- Select the cells.
- Click the arrow next to Borders and choose More Borders. You can also press Ctrl+1 or right-click the selection and choose Format Cells, then open the Border tab.
- Under Line, click the thickest solid line in the Style box. It sits near the bottom of the right column, just above the double line.
- Open the Color list and pick a color if you want something other than black.
- Under Border, click the bottom edge button, or click the bottom edge of the preview diagram. The preview shows the heavy line along the bottom.
- Check that no other edges are turned on in the preview, then click OK.
The bottom of the selection now uses your line style and color. Pick the double line in the Style box instead if you want the classic accounting look under a total.
When the bordered table is ready to print, center the worksheet on the printed page so it does not sit in the top-left corner.
How to Make an Existing Border Thicker
Excel uses a thin line by default when you add a border, so many sheets already have a thin line you want to replace.
- Select the cells that already have the border.
- Right-click and choose Format Cells, then open the Border tab.
- Choose a thicker solid line in the Style box.
- Click the existing border in the preview, or the matching Presets button, to apply the new style to it. Click it once; clicking a second time removes that edge.
- Check the preview, then click OK.

The thin line is replaced by the heavier one. If only part of the line changed, some of the cells had a different border; select the whole range again and repeat the steps.
Where the Line Appears on a Range
Excel treats a selected range as one block. That has two practical effects:
- Multiple rows: if you select A5:H12 and apply Thick Bottom Border, the heavy line appears only under row 12, the last row of the selection. To put a heavy line under every row, use More Borders and add both the bottom edge and the inside horizontal line in the preview.
- Whole rows: clicking a row number selects all 16,384 columns, so the line runs across the entire sheet. Select only the columns that hold data, such as A5:H5, if you want the line to stop at the edge of your table.
Borders also sit on shared edges. A thick bottom border under row 5 is the same line as a top border on row 6, and when two different borders meet on one edge, the one applied most recently wins.
How to Add a Thick Bottom Border in Excel for Mac
- Select the cells.
- On the Home tab, click the arrow next to the Borders button.
- Choose Thick Bottom Border.
For a custom weight or color, choose More Borders, or press Command+1 to open Format Cells and use the Border tab the same way as on Windows. Microsoft’s Mac shortcut list includes Command+Option+Down Arrow to add an outline border to the bottom of the selection; it draws a thin line, so open Format Cells afterward if you want it heavier.
How to Add a Thick Bottom Border in Excel for the Web
Excel in a browser also has a Borders button in the Font group on the Home tab, but its list of presets and line styles can be shorter than the desktop app’s. If Thick Bottom Border or the line style you want isn’t listed:
- Open the Editing menu near the top right of the window.
- Select Open in Desktop App and follow the Windows or Mac steps above.
- Save the file. The border stays when you reopen it in the browser.
How to Get a Border Thicker Than Excel Allows
The thickest solid line is the heaviest built-in option. When you need a bolder line, for example on a printed form, draw a shape over the cells instead:
- On the Insert tab, click Shapes and choose a straight Line (or a Rectangle for a heavy box).
- Hold Alt while you drag so the shape snaps to the cell edges. Hold Shift as well to keep a line perfectly straight.
- On the Shape Format tab, open Shape Outline, choose Weight, and pick a heavier weight, or select More Lines to type an exact width. For a rectangle, also set Shape Fill to No Fill.
- Right-click the shape, choose Format Shape, open Size & Properties, and under Properties choose Move and size with cells.
The shape now looks like an extra-heavy border and moves when you insert rows or resize columns. Shapes are not cell formatting, so they don’t move when you sort data and they aren’t copied with Format Painter.
Other Ways to Apply a Thick Bottom Border
- Draw Borders: click the Borders arrow, choose Line Style and pick the thick line, then choose Draw Borders. The pointer becomes a pencil; drag along the bottom edge of the cells. Press Esc to stop drawing.
- Format Painter: select a cell that already has the border, click Format Painter on the Home tab, then click or drag across the target cells. This copies all of the cell’s formatting, not only the border.
- Cell style: on the Home tab, choose Cell Styles > New Cell Style, name it (for example “Header line”), click Format, set the thick bottom border on the Border tab, and click OK twice. Apply it later from the Custom section of Cell Styles.
How to Remove the Thick Bottom Border
Select the cells, click the arrow next to Borders, and choose No Border to clear every border on those cells. To remove only one line, choose Erase Border, click the lines you want gone, and press Esc when you’re done. Right after adding a border by mistake, Ctrl+Z undoes it.
To confirm what’s left, select a cell, press Ctrl+1, and look at the preview on the Border tab. It shows every edge that still has a line.
If the Thick Bottom Border Doesn’t Work
- The Borders button is grayed out. The sheet is probably protected. On the Review tab, select Unprotect Sheet and enter the password if asked. Don’t remove protection on a shared or work file without the owner’s permission. Editing a cell (a blinking cursor in the cell) also disables the ribbon; press Enter or Esc first.
- You can’t see the line. Click an empty cell so the selection highlight doesn’t hide it, and zoom in with the slider in the bottom right corner. A dark fill color can also hide a black line; pick a contrasting line color in More Borders.
- The line is under the wrong row. Check the Name Box to the left of the formula bar to confirm which range is selected, press Ctrl+Z to undo, and select the correct cells.
- Extra lines appeared. You probably chose an option such as All Borders or Outside Borders. Undo, or use No Border and apply Thick Bottom Border again.
- The line looks thin when printed. Fit to page scaling shrinks everything, including borders. Check File > Print and the scaling setting, and preview the page before printing.
Excel Border Questions
Will the thick bottom border print?
Yes. Cell borders appear on printed pages, unlike gridlines, which print only if you turn them on. If you’d rather print the full grid, turn on gridline printing in Excel.
If the sheet spans several pages, repeat your bordered header row on each printed page and the border prints on every page too.
Why did the cell below mine get a border too?
The two cells share that edge, so a bottom border on one is the top border of the other. The most recently applied border is the one that shows.
Does the border stay with the data when I sort?
Yes. Borders are cell formatting, so they move with the cells when you sort. That can move a “totals” line into the middle of a list, so keep totals rows outside the range you sort. If you clear data later, deleting data but keeping the formatting leaves your borders in place.
Can I make a thick bottom border in a different color?
Yes. Use More Borders, pick a color in the Color list before you click the bottom edge, and click OK. You can also set Line Color in the Borders menu before using Draw Borders. To shade the cells as well, follow our steps to color cells in Excel.
What’s the difference between a thick bottom border and underline?
Underline sits under the text and is only as wide as the text. A bottom border runs along the full width of the cell, and it shows even when the cell is empty.
To mark up a sheet in other ways, insert an arrow in Excel or split a cell diagonally with a border.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.