Indent Text Within Spreadsheet Cells in Excel

  1. Top 10 Help Pages
  2. Recent Additions
  3. Instructions
  4. Show All Help Pages
  5. Contact Information
  6. Atomic Learning
  7. CedarInfo
  8. CedarNet
  9. Google Apps
  10. Google Calendar
  11. Google Drive
  12. Google Groups
  13. Google Mail
  14. Google Sites
  15. Microsoft Excel
  16. Microsoft Outlook
  17. Microsoft PowerPoint
  18. Microsoft Word
  19. Miscellaneous
  20. Moodle
  21. Other Software
  22. Personal Computers and Devices
  23. TechStop
  24. University Hardware
  25. Windows

Indent Text Within Spreadsheet Cells in Excel

How to indent text within spreadsheet cells in Excel. 

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.

Using the Increase Indent Button

  1. Enter your text into the document.
  2. Select the cell(s) whose entries you want to indent. (Make sure the cursor is not blinking within the selection.)
  3. Under the "Home" tab, in the "Alignment" group, click the "Increase Indent" icon (right-facing arrow pointing towards lines that resemble text). Each time you click the button, the selected text will indent further to the right.
  4. If you go too far, select the "Decrease Indent" icon (back-facing arrow) to move the text back toward the left.

Using Multiple Lines of Text Using Wrap Text Option

The wrap text option is useful if your text entry extends beyond the right edge of the cell. These instructions will show you how to change a cell's text alignment, so that the text wraps within the cell.

  1. Select the cell.
  2. 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.

Indenting Individual Lines of Text in a Cell

While you can change the indentation for a whole cell, you can not automatically indent individual lines of a cell. However, you can still get this effect by completing the following steps:

  1. Select the desired cell(s).
  2. Turn on "Wrap Text" using the instructions above.
  3. Click your cursor into the desired cell.
  4. Type the desired text. To go to a new line, press [Alt]+[Enter].
  5. To indent individual lines of text, use the space bar to insert the desired space.
Warning!
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 2016, office 2013, office 2010, wrap text, show all text

Posted in Computer Help