Outside Border Shortcut in Excel: Windows and Mac

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the cell or range and press Alt, H, B, O in sequence to apply Outside Borders. You can also press Ctrl+Shift+& to apply an outline border to the selection. The first shortcut opens the ribbon command directly; the second is a dedicated keyboard shortcut.

What an outside border does

An outside border draws a line around the edge of the selected cell or group of cells. If you select a single cell, the border surrounds that cell. If you select a rectangular range such as B2:D6, the border goes around the perimeter of the whole range. It does not, by itself, add lines between the cells inside that range.

This is useful when you want to distinguish a block of figures, frame a heading, or make a small table stand out without filling every cell with grid-like lines. Worksheet gridlines are different: they are the faint guides Excel displays across a sheet, and they are not normally printed. A cell border is formatting applied to the cells, so it can appear in printouts and remains visible when gridlines are hidden.

Use Alt, H, B, O on Windows

The letters are Excel KeyTips, not a four-key chord. Press and release each key in turn; do not hold Alt while typing H, B, and O. The sequence works from the worksheet when the workbook is open:

  1. Select one cell or the range that needs a border.
  2. Press and release Alt. Excel displays KeyTips over ribbon tabs.
  3. Press H to open the Home tab commands.
  4. Press B to open the Borders menu in the Font group.
  5. Press O to choose Outside Borders.

If the letters shown on screen differ, follow the visible KeyTips; they can vary with the interface language or version. The menu route is Home > Font > Borders > Outside Borders. The Borders control is the small dropdown in the Font group, near the fill-color and font-color controls. Opening the dropdown and clicking Outside Borders does the same job as the KeyTip sequence.

Use the direct outline-border shortcut

For a quick border around a selection in Windows desktop Excel, press Ctrl+Shift+&. Excel describes this as applying an outline border. For an ordinary rectangular selection, that gives the same useful perimeter effect as Outside Borders. It is especially handy when you are formatting many separate ranges and do not want to navigate the ribbon each time.

The ampersand key can be awkward on some keyboard layouts because it may require an additional key or use a different physical key. If the shortcut does not produce the expected result, use Alt, H, B, O or the Borders dropdown instead. The Ctrl+Shift+& shortcut is not the same as Ctrl+B, which applies bold formatting to text, and it does not choose a thick line or a custom color.

Choose a border style, color, or weight

The keyboard shortcut is designed for speed, not detailed styling. If the default line is too light or too heavy for your sheet, open the Borders dropdown and choose the line style or color before applying the border. Excel’s menu includes border-style and line-color controls, followed by commands for applying borders to particular edges. The exact appearance may depend on the formatting currently selected in that menu.

For example, to create a strong frame around a monthly summary, select the summary range, choose a thicker line style, and then apply Outside Borders. To distinguish a totals row without framing the entire table, select that row and choose a top or bottom border instead. A thin neutral line is often clearer for dense data; thick, colored rules can be useful for a presentation but may make a worksheet harder to scan if overused.

It is worth previewing the result at normal viewing size and in Print Preview. A line that looks subtle on screen may be prominent on paper, while a pale border can disappear when printed. Border formatting does not change cell values, formulas, or number formats, so it can be adjusted without changing the underlying data.

Outside Borders versus other border commands

The Borders menu offers several commands that sound similar but produce different results. Choosing the wrong one is a common reason a selected table looks busier or less defined than intended:

  • Outside Borders: adds a frame around the outside edge of the selected range.
  • All Borders: adds the outside frame and lines between cells within the selection.
  • Bottom Border: adds a line only along the bottom edge of the selected cells.
  • Thick Outside Borders: emphasizes the perimeter with a heavier line than the standard outside-border choice.
  • No Border: removes borders from the selected cells.

For instance, selecting A1:C5 and choosing All Borders creates a visible grid of 15 cells. Choosing Outside Borders frames the three-column-by-five-row block but leaves the interior without added dividing lines. If the cells already have interior borders, applying an outside border does not generally remove those existing lines. Use No Border first only when you intend to clear the selected cells’ existing borders and then start again.

Practical examples for worksheets

For a report, you might select the full data block, such as A1:D12, and apply Outside Borders to give it a clear edge. Then select A1:D1 and use a bottom border or a fill color to distinguish the headings. This keeps the table’s perimeter defined without drawing a line around every individual value.

For a small total box, select the label and result together, perhaps F3:G3, and apply an outside border. If you want the total to stand out more, use bold text or a fill color as a separate formatting choice. The border itself does not communicate whether a number is a subtotal, tax, or final amount; labels and consistent worksheet design still matter.

When applying borders to a large selection, verify the selection before pressing the shortcut. If you accidentally select an entire column, Excel can frame the column’s full selected area rather than just the visible data. Selecting the intended cells first is safer than trying to repair an unexpectedly large border afterward.

Common problems and how to fix them

If Alt, H, B, O does nothing, press Alt once and look for the KeyTips before continuing. The sequence expects the ribbon to be active, and typing the letters too quickly or holding Alt throughout can lead to a different result in some setups. You can always use the Home tab and click the Borders dropdown as a fallback.

If a border appears on the wrong cells, undo immediately with Ctrl+Z on Windows, then reselect the intended range and apply it again. Undo is useful for a recent formatting action, but it may also reverse other actions if you continue working after the mistake. Check the selected range in the Name Box or by looking at the highlighted cells before applying formatting.

If the shortcut seems to add lines inside the range, check whether the chosen command was All Borders rather than Outside Borders. If a border seems missing, inspect the line color and style: a white line on a white background, or a very fine line at a distant zoom level, can be difficult to see. Also check whether the selected cells already contain border formatting and whether the command you used changed only a particular edge.

Mac and Excel for the web

On Excel for Mac, use the ribbon route Home > Borders > Outside Borders if you want an unambiguous equivalent. A commonly listed Mac shortcut for an outline border is Command+Option+0, but shortcuts can depend on the Excel release, macOS settings, and keyboard layout. If that combination is unavailable or intercepted by the system, use the menu rather than assuming the Windows Alt sequence will behave identically.

In Excel for the web, select the cells and use the Home tab’s Borders menu to choose Outside Borders. Browser and operating-system shortcuts can interact with Excel for the web, so the ribbon command is the dependable option when a key combination is intercepted. The visual result is the same: a border around the selection’s perimeter, not a set of lines between every cell.

Frequently Asked Questions

What is the shortcut for Outside Borders in Excel?
In desktop Excel for Windows, press Alt, H, B, O one key at a time. Ctrl+Shift+& is a second option for applying an outline border to the selected cells.

Does Ctrl+Shift+& add borders between cells?
It applies an outline border around the selected range; it is not the All Borders command. Use the Borders dropdown and choose All Borders when you also want internal cell lines.

How do I put a border around one cell?
Select the cell and choose Home > Borders > Outside Borders, or use the Windows shortcut. With just one cell selected, its outside edge is the cell’s perimeter.

How do I remove an outside border?
Select the affected cells and choose Home > Borders > No Border to remove their borders. Be aware that this clears other borders in the selected cells too, not just the outer frame.

Will an Excel cell border print?
Yes. Cell borders are formatting and can print with the worksheet. Gridlines are a separate display and print setting, so a border is a better choice when you need a visible frame in a printed report.

A quick way to remember it

For Windows, remember Alt, H, B, O: Home, Borders, Outside. Use Ctrl+Shift+& when you want the fast outline-border shortcut, and use the Borders menu whenever you need a particular color, thickness, or edge. Confirm the selection before applying either method, especially when formatting a large worksheet.

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.