1/27/2023 0 Comments Indent format in excelOn the other hand, if you add an indent to an alignment that doesn't support indents, Excel will automatically switch alignment to left-aligned text. If you switch to an alignment that doesn't support indents, the indents will be removed. The current indent setting is displayed next to the Horizontal alignment menu.Īs you can see in the menu, only certain alignment options support indents. You can also see and set the indent level using the Format Cells dialog box. However, when text is right-aligned, the indent is from the right edge of the cell. When text is left-aligned, the indent is from the left edge of the cell. And then further indent sub categories under Housing and Transportation. For example, we can indent all expenses under the Expense category. Once you reach zero, clicking decrease indent has no further effect.īecause indents can be set in steps, Excel allows you to have multiple levels of indentation. One button increases the indent by one step, and the other button decreases the indent by one step. The easiest way to indent is to use the Indent buttons in the Alignment group on the home tab of the ribbon. Let's apply some indentation to make the categories a little more readable. Indents work in steps, allowing you to use more than one level of indentation. Excel provides a simple way to horizontally indent cell content.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |