In Excel for Microsoft 365 on Windows, select the cell or range and press Alt, H, B, B, one key after another, to apply a bottom border. The ribbon route is Home > Borders > Bottom Border; it is useful when you want to confirm the command or choose another border style.
The Windows shortcut, key by key
The shortcut uses Excel’s ribbon KeyTips rather than a single simultaneous key combination. Press and release Alt to show KeyTips, press H for the Home tab, press B to open the Borders menu, then press B for Bottom Border. You do not hold all four keys down at once. Select the target cells before starting the sequence.
On a standard English-language Microsoft 365 installation, the final B selects Bottom Border from the Borders menu. KeyTips may vary in another display language or after ribbon customization. If the letters shown on screen do not match, follow the visible KeyTips, or use the mouse route: Home > Font group > Borders dropdown > Bottom Border.
The command applies the border using the currently available bottom-border formatting. In a typical default workbook, that is a thin, solid line. If you need a different color or weight, choose it from the Borders dropdown rather than assuming the shortcut will create a particular decorative style.
What the command changes
A cell border is formatting around a cell, separate from the contents and the worksheet gridlines. Bottom Border adds a line along the lower edge of the selected cell or range. It does not insert a row, underline the text, or change a number format. The border remains part of the cell formatting when you edit the cell’s value.
For a single cell, the command draws along that cell’s bottom edge. For a rectangular selection such as A2:D10, it applies the bottom border along the lower edge of the selected range, rather than adding a line under every row inside the selection. Existing borders on other edges are generally left in place; applying a bottom border is not the same as replacing all borders.
That makes the shortcut handy for emphasizing the end of a section or marking the bottom of a block of figures. It is also useful when you want to distinguish a total row from the data above it without filling cells with a color. The border is a visual cue only: it does not affect formulas, sorting, or calculations.
Apply a bottom border step by step
- Click a cell, or drag across the cells that need a shared bottom edge. To format a whole row, click its row number first.
- Press Alt, H, B, B in sequence. Watch the KeyTips if you are unsure which menu item Excel is about to choose.
- Check the lower edge of the selection. If the result is too faint, too dark, or the wrong style, open Home > Borders and select a more suitable option.
For example, if a monthly report has its subtotal in row 14, select the subtotal cells—perhaps B14:E14—and apply Bottom Border. The line appears beneath that selected row of cells, helping separate the subtotal from the next section. If you select B10:E14 instead, the border marks the bottom of the entire selected block, not each row in it.
You can also select several separate cell ranges by holding Ctrl while selecting them on Windows, then use the shortcut. Excel applies the formatting to each selected area. Check the selection before pressing the keys: a mistaken whole-column selection can create borders across many more cells than intended.
Choose the right selection for the result
What you select determines where the line appears. Selecting only the cells in a heading applies the border beneath that heading’s cells. Selecting an entire row applies it across the row, including blank cells. Selecting a block of rows gives the block one bottom edge. This is why a border may seem to appear in an unexpected place: Excel follows the selection boundary, not the position of the active cell alone.
Use the smallest range that expresses the layout you want. For a total spanning columns B through E, select B14:E14 rather than the whole worksheet row if you want the line to stop at the report’s edge. For a divider that should run across a full row, selecting the row number is more direct. If the border seems incomplete, check for gaps in the selected range or cells that are outside the intended selection.
Bottom Border is not the right choice when you want horizontal separators between every row of a table. In that case, select the table range and use an appropriate inside-border option from the Borders menu, or format the data as an Excel table. Applying Bottom Border repeatedly to individual rows can work, but it takes longer and makes later layout changes harder to manage.
Related border shortcuts and options
Bottom Border is one item in a larger set of border commands. Two other Windows shortcuts are often confused with it: Ctrl+Shift+& applies an outline border to the selected cells, while Ctrl+Shift+_ removes the outline border. These are not substitutes for the Bottom Border shortcut. The outline command affects the perimeter of the selection, whereas Bottom Border targets its lower edge.
For other border patterns, open Home > Borders and choose the named option that matches the layout. Depending on the option selected, Excel can add top, left, or right edges, all borders, or an outside border. The dropdown also provides access to line styles and colors. The exact choices visible can depend on the Excel version and window layout, so read the menu labels rather than guessing a key sequence.
A common misconception is that Ctrl+U adds a bottom border. In Excel, Ctrl+U applies underline formatting to cell contents; it does not draw a cell edge. Underlining may look similar for text in one cell, but it will not create a continuous rule across a range or appear beneath blank cells. Use the border command when you need a line attached to the cell boundary.
Mac and Excel for the web
The Windows sequence Alt, H, B, B is designed around Windows ribbon KeyTips, so do not assume it works the same way in Excel for Mac. On a Mac, select the cells and use Home > Borders > Bottom Border. The ribbon route is the dependable way to apply this particular border when the Windows key sequence is unavailable or behaves differently with your keyboard setup.
Excel for the web also has a Borders control on the Home tab. Select the cells, open the Borders dropdown, and choose Bottom Border. Browser shortcuts and access-key behavior can depend on the browser and may be intercepted by it, so the visible ribbon command is often the clearest option in the web app. The Windows instructions in this article are for the desktop version of Microsoft Excel for Microsoft 365.
Troubleshooting a missing or unexpected line
- The shortcut opens the wrong menu: Press the keys in sequence, not as one chord, and follow the KeyTips displayed after Alt. A different Office language can use different letters.
- The line is difficult to see: Gridlines are not cell borders, and their appearance can be subtle. Open the Borders menu and choose a more visible line style or color.
- The line appears beneath the wrong cells: Review the highlighted selection. Excel places the border at the lower edge of the selected cell or range.
- The line does not print as expected: Worksheet gridlines and formatted borders are different. A border is cell formatting; check Print Preview to confirm the printed layout.
- Some cells look different: Existing formatting, merged cells, or a partial selection can affect how the result looks. Try selecting the intended range again and applying the border to that range.
If the shortcut does not seem to do anything, first make sure Excel is active and that you have selected worksheet cells rather than a chart, shape, or text box. Then use the ribbon route once to verify that Bottom Border is available for the current selection. For a particularly complex range, selecting a smaller test area can help identify whether the issue is the selection or the border style.
When a border is better than other formatting
A bottom border is a practical way to separate a heading, subtotal, or final row while keeping the cell fill unchanged. It can make printed reports easier to scan and can create a clear visual endpoint for a small table. Use a consistent style across related sections; varying border weights without a clear reason can make a worksheet harder to read.
For structured data that will grow as new rows are added, consider formatting the range as an Excel table through Insert > Table. Table styles can provide alternating row shading and consistent header formatting as the table expands. A manually applied bottom border is often simpler for a small report, but it may need to be reapplied or adjusted when the layout changes.
Conditional formatting is another option when a line or emphasis should respond to changing values, but it is not a direct replacement for every border task. For a one-time visual rule, the Bottom Border command is straightforward. For a reusable report, choose a format that remains clear when values, row counts, or print settings change.
Frequently Asked Questions
What is the shortcut for a bottom border in Excel?
In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, B, B in sequence. This opens the Home tab’s Borders menu and selects Bottom Border.
Does Alt+H, B, B add a border to every selected row?
No. For a multirow rectangular selection, Bottom Border marks the lower edge of the selected range. To add separators between rows, use an inside-border option or format the rows individually.
How do I add a bottom border in Excel on a Mac?
Select the cells, then use Home > Borders > Bottom Border. The Windows Alt-key sequence is not a universal Mac shortcut.
How do I remove a bottom border?
Open Home > Borders and choose No Border only if you intend to clear the relevant borders on the selection. If other edges must remain, use the menu to change only the bottom edge or adjust the border settings carefully.
Is Ctrl+Shift+& the bottom-border shortcut?
No. In Windows Excel, Ctrl+Shift+& applies an outline border to the selected cells. Use Alt, H, B, B for Bottom Border.
Related
- Excel Named Range Rules: Names, Scope, and Limits
- Excel Named Range Scope: Workbook vs. Worksheet Names
- Excel Named Range Manager: How to View and Edit Names
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Does Excel Have Box Plots? How to Create OneYes. Microsoft Excel for Microsoft 365 includes a built-in Box and Whisker chart, which is Excel’s name for…
- How to Add a Picture to a Cover Page in Microsoft WordTo add a picture to a Word cover page, open the first page, choose Insert > Pictures >…
- MS Outlook Out of Office: How to Set It UpTo set an out-of-office reply in Microsoft Outlook for Microsoft 365 on Windows, open Outlook and select File…
- How to Remove a Filter in Google SheetsTo remove a standard filter in Google Sheets, open the sheet in a web browser, select the tab…
- Excel Import CSV Data: Steps, Settings, and FixesTo import CSV data into Excel for Microsoft 365 on Windows, open a blank workbook, select Data >…
- How to Create a Sticker Template in Word for PrintingTo create a sticker template in Microsoft Word, open Mailings > Labels > Options, select the label product…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.