Keyboard shortcuts for applying borders to cells

Article translations Article translations
Article ID: 300169 - 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 keyResult
ALT+TApply or remove the top border.
ALT+BApply or remove the bottom border.
ALT+LApply or remove the left border.
ALT+RApply or remove the right border.
ALT+DApply or remove the downward diagonal border.
ALT+UApply or remove the upward diagonal border.
ALT+HApply or remove the horizontal interior border.
ALT+VApply or remove the vertical interior border.

Properties

Article ID: 300169 - Last Review: June 4, 2007 - Revision: 2.0
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbenable kbhowto KB300169

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com