Jump to content

Indent text in a cell


Recommended Posts

Indent text in a cell

Pressing [Tab] in Excel 2000 doesn't indent text in a cell; it simply moves the cell pointer to the next cell. Beginning Excel users might hard-code the indent by pressing the spacebar several times before entering text into a cell. But this approach is fraught with problems.

To indent text in a spreadsheet cell, use the Formatting toolbar's Increase Indent button. Enter your text without any lead spaces, select the cells whose entries you want to indent, and click the Increase Indent button. Each time you click that button, Excel nudges the selected text to the right. If you go too far, you can click 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'll probably want to change that cell's text alignment so that the text wraps within the cell. To change the text alignment, select the cell and go to Format | Cells | Alignment. In the Text Control section, select Wrap Text and click OK. When you do this, Excel indents all of the lines of text in the cell.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...