Indent text in Excel is necessary for fitting titles and column names in the datasheet. There are times that titles are long and you cannot shorten or abbreviate the text in a cell. A small feature, but very very useful. Align text and indent text in Excel is the feature that everyone should know.
How to do Indent Text in Excel Sheet
- Open the excel sheet whose data you wish to indent.
- Highlight the cell/ cells you wish to indent, making sure the cursor is not blinking within the selection.
- Under the “Home” tab, under the “Alignment” group, press the “Increase Indent” icon which is a right-facing arrow.
- With each button click, the highlighted text will indent towards the right side.
- Choose the “Decrease Indent” icon which is a back-facing arrow to move the text back toward the left in case you go overboard with “indent text”.
How to do Indent Using Wrap Text
This option is suitable if the text entry extends beyond the right edge of the cell.
- Highlight the specific cell.
- Under the “Home” tab, choose the “Alignment” option,
- Press the “Wrap Text” option.
- As a result, Microsoft Excel will visibly make the contents display in multiple lines.
How to indent text in Excel within a cell
It is also possible to indent individual lines in specific cells rather than the whole row.
- Highlight the cell or cells.
- Switch on the ”Wrap Text”.
- Point the cursor into the desired cell.
- After typing the desired text in the cell, move to a new line, and press [Alt]+[Enter] together.
- In order to indent individual lines of text, a space bar can be useful to insert the desired space.
How to indent text in Excel by changing the value in the Indent option
Alternatively, you can go to the Alignment tab from the Format Cells menu, select the alignment for horizontal and vertical directions and update the points from the Indent split box.
Excel enables an individual to format the data in a cell in numberless ways. The most common formatting option one can apply is by indenting the contents of a cell or cells by a marginal amount.
You may also like:
- How To Delete Multiple Rows in Excel Sheet at Once
- How to Do Regression Analysis in Excel
- How to Create a Waterfall Chart in Microsoft Excel?