MS Office Excel: Reduce indentation
In Excel, you can reduce and enlarge the indentation at certain intervals in order to improve the clarity of your tables. Our instructions show you how this works.
Set indent size in Excel cells
In Excel you can determine the size of the indentation in a few steps:
- Select the cell (s) whose indentation you want to reduce
- Right-click to open the context menu and select "Format cells ...". Alternatively, you can use the key combination [Ctrl] + [1].
- Then click the "Targeting" tab.
- Set the text alignment to "Left (indent)".
- Enter an integer between 1 (no indent) and 15 (maximum indent) in the "Indent" field next to it.
- To change a right-aligned text indentation, select "Right (indentation)" under text alignment and enter the desired indentation value.
- Confirm with OK".