Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Indent Option on Alignment Tab Not Available with General Alignment


View products that this article applies to.

This article was previously published under Q211575

↑ Back to the top


Symptoms

When you click the Alignment tab in the Format Cells dialog box, the Indent option under Text alignment is unavailable (appears dimmed).

↑ Back to the top


Cause

The Indent option is only available when you click Left (Indent) in the Horizontal box in the Format Cells dialog box; however, the default setting for text alignment is General. When you select any other item in the Horizontal box, the Indent option appears dimmed.

↑ Back to the top


More information

When you type a value in the Indent box, or click the arrows, the Indent option no longer appears dimmed, and the Horizontal box automatically changes from General to Left (Indent).

NOTE: Clicking Increase Indent on the Formatting toolbar produces the same result as typing or selecting a value in the Indent box.

To indent text in a cell, use either of the following methods.

Method 1: From the Formatting toolbar

Select the text and click Increase Indent on the Formatting toolbar.

NOTE: If you click Increase Indent several times and the cell to the right of the active cell is blank, the text you are aligning may be positioned over the blank cell, or over columns to the right of the active cell.

Method 2: From the Format Cells Dialog Box

1.Select the text.
2.On the Format menu, click Cells.
3.Click the Alignment tab.
4.In the Horizontal list, click Left (Indent).
5.In the Indent box, type or select the amount by which you want to indent the text.
6.Click OK.

↑ Back to the top


References

For more information about indenting text, click Microsoft Excel Help on the Help menu, type Indent data in a cell in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top


Keywords: KB211575, kbprb

↑ Back to the top

Article Info
Article ID : 211575
Revision : 3
Created on : 9/25/2003
Published on : 9/25/2003
Exists online : False
Views : 250