Keyboard shortcuts for applying borders to cells

View products that this article applies to.

This article was previously published under Q300169

Expand all | Collapse all

SUMMARY

This article contains the keyboard shortcuts that you can use to create borders on the Borders tab of the Format Cells dialog box in Microsoft Excel 2002 and in Microsoft Office Excel 2007.

Note Press CTRL+1 to display the Format Cells dialog box.

MORE INFORMATION

The following table lists the keyboard shortcuts that you can use on the Borders tab of the Format Cells dialog box.

Collapse this tableExpand this table

Shortcut key	Result
ALT+T	Apply or remove the top border.
ALT+B	Apply or remove the bottom border.
ALT+L	Apply or remove the left border.
ALT+R	Apply or remove the right border.
ALT+D	Apply or remove the downward diagonal border.
ALT+U	Apply or remove the upward diagonal border.
ALT+H	Apply or remove the horizontal interior border.
ALT+V	Apply or remove the vertical interior border.