Excel: Indent Text within Spreadsheet Cells
Pressing the [Tab] key in Excel does not indent text in a cell; it simply moves the cell pointer to the next cell. To indent text in a cell, follow the steps below.
- Enter your text into the document.
- Select the cell(s) whose entries you want to indent.
- Under the "Home" tab, in the "Alignment" group, click the "Increase Indent" button.
- Each time you click the button, the selected text will nudge to the right.
- If you go too far, select the the "Decrease Indent" button to nudge the text back toward the left.
If your text entry extends beyond the right edge of the cell, you will probably want to change that cell's text alignment so that the text wraps within the cell with the following instructions.
- Select the cell.
- Under the "Home" tab in the "Alignment" group, choose "Wrap Text."
- Excel will make the contents of each cell visible by displaying it on multiple lines.
While you can change the indentation for a whole cell, you can not automatically indent individual lines of a cell. For example, Excel doesn't have an option to make the first line of a cell flush left and the second line of a cell indented. However, if you would still like to get this effect, complete the following steps:
- Select the desired cell(s).
- Turn on "Wrap Text" using the instructions above.
- Click your cursor into the desired cell.
- Type the desired text. To go to a new line, click [Alt]-[Enter].
- To indent individual lines of text, use the space bar to insert the desired space.
When you indent individual lines of a cell by inserting spaces, note that the formatting may change if you resize the cell.
Keywords: excel tab, tab cell in excel, office 2010, wrap text, show all text