Excel – Indenting Cell Contents
The contents of a cell can be left-aligned, right-aligned, or centered. By default, numbers are right-aligned, and text is left-aligned. Figure 1 shows a table of data that uses the default alignment. As you can see, entries in the Sales and Region columns appear right next to each other, making it difficult to read.
One solution is to change the alignment of the Region column. By making the text centered or right-aligned, the text wouldn’t be next to the numbers in the Sales column. Another option is to indent the Region text.
To indent, start by selecting the cell or range. Then press Ctrl+1 to display the Format Cells dialog box. Click the Alignment tab and specify a nonzero value for the Indent setting (see Figure 2). The direction of the indentation depends on the Horizontal alignment choice (Left or Right).
Figure 3 shows the original table after indenting the Region names one space. Alternatively, you can indent the values in the Sales column to provide a space after each number. Either choice improves the legibility.