When you want to indent the content in one, or more cells: Click to highlight one or more cells.; In the Home tab in the Alignment section click the Increase indent button (it has an arrow to the right). This indents the content two character spaces. To indent more, just click the Indent button again.; NOTE: If you change your mind, you can use the Decrease Indent. Select the cells containing text you want to indent. On the Home tab, in the Alignment group, click the Increase Indent button. Each time you click the Increase Indent button, Excel adds a small amount of space between the cell border and the data. Step 4: Under 'Indentation' section in the 'Paragraph' window, type the numbers for inside and outside indentation; Step 5: Click 'OK' to finish. If you only want to increase indent only for the first line in each paragraph, please check how to indent the first line of each paragraph.
Increase Indent Button Excel
Increase Indent Button Excel
When you think of indenting information, you normally think of a word processor. It is not unusual to indent paragraphs or specific lines of information on the screen. Excel, while definitely not a word processor, allows you to easily indent information within a cell.
To set the indent to be used in a cell, follow these steps:
- Select the cells you want to format.
- Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
- Make sure the Alignment tab is selected. (See Figure 1.)
- Using the Indent control, specify the number of characters by which the cell contents should be indented. You can pick any whole number between 0 and 15.
- Click on OK.
Figure 1. The Alignment tab of the Format Cells dialog box.
Each number of indent moves the contents of the cell about one character width to the right. (There goes that strange character measurement system in Excel again.) You can also control the indentation of cell contents by using the two indent tools on the Formatting toolbar. Each click of a tool moves the cell contents one position to the left or right.
Unindent In Excel
Increase Indent Excel 2016
If you have set up a cell so that text wraps within the cell, then indentation affects all the lines of text within the cell—not just the first line.