To add a bottom border in Excel for Microsoft 365 on Windows, select the cell or cells, then choose Home > Borders ▼ > Bottom Border. The border appears along the bottom edge of each selected cell; it is formatting, not a character or value in the cell.
What a bottom border does
A cell border is a line placed on one or more edges of a cell. A bottom border marks the lower edge, making it useful for separating a heading from its data, drawing a line beneath a subtotal, or dividing rows in a table. It remains attached to the cell formatting as you edit the contents, unlike a line drawn as a shape.
For example, if a monthly expense table has category names in column A and amounts in column B, you might put a bottom border beneath the header row to distinguish the labels from the entries. You could also place one under the final amount in a section to make a subtotal easier to spot. A border does not calculate a total, change a number format, or affect sorting by itself.
Excel’s worksheet gridlines are different. Gridlines are the faint guides that show cell boundaries on screen; they are not cell borders, and they are usually not printed by default. A bottom border is explicit formatting and can be printed. For print settings, check Page Layout > Sheet Options > Gridlines > Print to control gridlines separately.
Apply a bottom border from the ribbon
The Borders control is in the Font group on the Home tab. The icon may show a small grid or the most recently used border, so use its drop-down arrow to see the available choices. The standard steps are:
- Select a cell, a row of cells, or a range where the border should appear.
- On the ribbon, select Home > Borders ▼.
- Choose Bottom Border from the menu.
- Click a blank cell or inspect the range to confirm the line is on the intended edge.
With a single cell selected, the command puts a line on that cell’s bottom edge. With multiple cells selected, Excel applies bottom-edge formatting to the selected cells. In a multirow range, this can create horizontal rules along the lower edges of the cells in the selection, rather than a single border only around the whole range. If you want just one line below a block, select the cells in the last row of that block before choosing Bottom Border.
To add a line beneath an entire heading row, select the heading cells across the columns you want to mark, then apply the border. Selecting only one cell will not extend the line across the rest of the row. Likewise, if a worksheet has headings in A1:D1 but the data table spans A:D, select A1:D1 rather than the whole worksheet.
Use the keyboard or repeat formatting
On Windows, Excel’s ribbon KeyTips provide a keyboard route: press Alt, then H, B, and B in sequence to open the Home-tab Borders menu and choose Bottom Border. These are sequential key presses, not a single four-key shortcut; the letters shown by KeyTips can depend on the ribbon language or version. You can also use the mouse if the sequence differs in your setup.
Ctrl+Shift+& applies an outline border to the selected cells, not specifically a bottom border, so it is not a substitute when you need only the lower edge. On Mac, use Home > Borders and choose Bottom Border; keyboard mappings differ from Windows, and a Windows shortcut may not work on a Mac. In Excel for the web, the Home tab’s Borders menu is also the straightforward way to apply the formatting.
If you want to repeat the last formatting action, select another target range and press F4 on Windows, or Ctrl+Y may repeat the last action where supported. Repeat behavior can depend on what you did most recently, so check the result rather than assuming Excel repeated only the border choice. The Format Painter is another option: select a cell that has the desired border, choose Home > Format Painter, and then select the destination cells. It copies other formatting too, such as font, fill, and number format, so use it carefully.
Change the border’s color, weight, or style
A plain, thin line is often sufficient, but Excel lets you customize border appearance. Open Home > Borders ▼ and choose a line color or line style from the available controls before applying the border. For more precise control, choose More Borders to open the Format Cells dialog box and use its Border tab. There you can select a line style and color, then apply it to the bottom edge in the preview.
The Format Cells dialog is useful when a border must match a report’s visual design. For example, a thicker solid line can distinguish a final total from ordinary rows, while a colored rule can identify a section. Use emphasis sparingly: several colors and line weights in one table can make the information harder to scan. Borders should clarify structure, not compete with the data.
In the Border tab, the preview shows which sides will be formatted. If you choose a style or color but do not activate the bottom-edge control in the preview, the appearance may not be applied. Conversely, selecting the bottom edge with no special style chosen generally uses the current or default line settings. Check the preview before confirming with OK.
Choose the right border for the job
Excel’s border menu includes options such as Bottom Border, Top Border, Left Border, Right Border, All Borders, and Outside Borders. The best choice depends on whether you need a rule beneath individual cells, a grid around each cell, or an outline around a whole selection.
- Bottom Border: marks the lower edge of the selected cell or cells. Use it for a header separator or a rule beneath a selected row.
- Outside Borders: draws an outline around the outside of the selected range. It does not add lines between every cell inside the range.
- All Borders: adds borders around the selected cells, including internal divisions. This is useful for a compact table, but can look crowded in a large data range.
- Top and Bottom Border: can frame a heading or total row without boxing in its sides. Use the More Borders controls if you need to apply both edges precisely.
A common misconception is that choosing Bottom Border for a rectangular range always draws only one continuous line at the bottom of the rectangle. If that is your goal, select the bottom row of the range first. If you select the entire multirow block, Excel formats the bottom edge of the selected cells, which can produce horizontal separators through the block as well.
Remove or correct a border
To clear borders from a selection, select the affected cells and choose Home > Borders ▼ > No Border. This removes border formatting from the selected cells; it does not erase their values, formulas, fills, or other formatting. If only one edge is wrong and other borders should remain, use More Borders, click the unwanted edge in the preview to turn it off, and confirm.
When a line seems to remain after choosing No Border, check whether it is a worksheet gridline rather than a border. Gridlines can be shown on screen even when no border formatting exists. To hide on-screen gridlines, use View > Show > Gridlines; to change whether they print, use the Page Layout sheet options. Those settings affect the worksheet view or printout, not the cell’s border format.
Another possible source of a visible line is conditional formatting. If a rule applies a border when a cell meets a condition, clearing ordinary borders may not remove the line while that rule remains active. Check Home > Conditional Formatting > Manage Rules, choose the relevant worksheet or selection in the display options, and inspect the rule’s format. Change or remove a rule only if you understand what other formatting it controls.
Printing and practical design tips
Explicit borders generally print with the worksheet, while gridlines need to be enabled for printing separately. Before printing a large table, use File > Print to preview the pages. The border may be technically present but fall at a page break, or a thin line may be difficult to see in the final output. Adjust scaling, page breaks, or the border weight if needed, and check the preview again.
For a useful, readable sheet, consider these points:
- Use a bottom border to separate a header or meaningful section, rather than adding a line after every row without a reason.
- Apply the border across the full width of the relevant table or heading.
- Choose a weight and color with enough contrast for the expected display or printout.
- Use cell styles or consistent formatting when multiple sections should share the same appearance.
- After pasting or sorting data, inspect the borders; copied formatting can extend a line farther than intended.
For a structured Excel table, the Table Design tab’s table styles can provide consistent row and header formatting. That may be easier to maintain than manually bordering every row, especially when the table expands. A direct bottom border is still useful for a specific subtotal or a one-off visual separation. If the desired line should adapt automatically as records are added, consider whether a table style or conditional formatting rule is a better fit than manual formatting.
Frequently Asked Questions
How do I add a bottom border to a whole row?
Select the cells across the row that should have the line, then choose Home > Borders ▼ > Bottom Border. Selecting the entire worksheet row is usually unnecessary; select the table columns instead to avoid formatting unrelated cells.
How do I put one border under a group of rows?
Select only the cells in the group’s last row and apply Bottom Border. Selecting the whole multirow block can add bottom edges to cells within the selection, creating extra horizontal rules.
Why can’t I see my bottom border?
Check that you selected the intended cells and applied Bottom Border, not a different edge. Also inspect the border color and style, because a white or very thin line can be hard to see. Use the Format Cells Border preview and check for conditional formatting that may affect the cell.
Will a bottom border print?
Cell borders normally print as worksheet formatting. Gridlines are separate and are not printed by default, so use File > Print to preview the result and confirm that the line is visible on the page.
How do I remove just the bottom border?
Select the cells, open More Borders from the Borders menu, and turn off the bottom edge in the Format Cells Border preview. Choose No Border only when you want to remove all border edges from the selection.
Related
- Bill Paying Checklist Excel Template: Build One That Works
- Billing Invoice Template Excel: Setup and Key Details
- Beyond Compare for Excel: How Spreadsheet Comparison Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Ungroup Excel Shortcut: Remove Row and Column GroupsIn Excel for Microsoft 365 on Windows, select the grouped rows or columns and press Alt+Shift+Left Arrow to…
- Google Sheets Jira Connector: Setup, Sync, and OptionsA Google Sheets Jira connector brings Jira issue data into a spreadsheet for reporting and analysis. The simplest…
- Excel Number Format: Meaning, Examples, and How It WorksIn Excel, a number format is the set of display instructions that controls how a cell’s value appears,…
- How to Flip Numbers Upside Down in Excel: Two MethodsTo turn numbers visually upside down in Excel, put them in a text box and rotate the box…
- Excel Freeze Panes Greyed Out? Causes and Fixes ExplainedIf Excel’s Freeze Panes command is greyed out, first switch to Normal view, finish editing any cell, and…
- Export Outlook Contacts to PST: Steps and OptionsYes. In classic Outlook for Microsoft 365 on Windows, go to File > Open & Export > Import/Export,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.