Indenting Cell Contents

Excel allows you to format the contents of a cell in a myriad of ways. One of the formatting options you can apply is to indent the contents of a cell by a certain amount. This is similar to indenting done in a Word processor, such as Word, except that the indenting is specified in a number of characters, not in a linear distance such as inches or points.

To set the indent to be used in a cell, follow these steps:

1. Select the cells you want to format.
2. Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
3. Make sure the Alignment tab is selected. (Click here to see a related figure.)
4. In the Horizontal drop-down list, choose Left (Indent). If you are using Excel 2002 or 2003, you can also choose Right (Indent).
5. Using the Indent control, specify the number of characters by which the cell contents should be indented from either the left or right side of the cell. You can pick any whole number between 0 and 15.
6. Click on OK.