Article ID: 156164
Article Last Modified on 10/21/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q156164
SYMPTOMS
When you press CTRL+ALT+TAB, Microsoft Excel fails to insert a tab character in the active cell.
CAUSE
This behavior occurs because Microsoft Excel 97 no longer uses this keystroke to position cell text; instead, Microsoft Excel uses text alignment features.
NOTE: In earlier versions of Microsoft Excel, you use the key combination CTRL+ALT+TAB, to indent text in a cell. This keystroke inserts eight spaces in the active cell rather than a tab character.
RESOLUTION
To indent text in a cell, use one of the following methods.
Method 1
Select the text and click Increase Indent on the Formatting toolbar.
Method 2
- Select the cell that contains the text you want to indent.
- On the Format menu, click Cells.
- Click the Alignment tab.
- In the Horizontal list, click Left(Indent) and type the amount by which you want to indent the text. Or, click the arrows in the Indent box.
- Click OK.
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.
REFERENCES
For more information about the Indent feature, click the Index tab in Microsoft Excel Help, type the following text
indenting data
and then double-click the selected text to go to the "Center, align, indent, or rotate data in a cell" topic.
Additional query words: XL97 shift space
Keywords: KB156164