When using Alignment and Indentation, common questions usually involve default alignment behavior, centering header text, and checking whether indentation changes are visible; this section includes 3 common questions and a glossary.
FAQ
Is the default alignment different for numbers and text?
- Enter both numbers and text in spreadsheet cells.
- Check their default display positions in the cells.
- If you want a consistent appearance, select the target cells and apply alignment manually.
In many spreadsheet workflows, numbers are right-aligned by default and text is left-aligned by default, and you can adjust them manually when needed.
How do I center-align header text?
- Select the header cell or the full header row.
- Tap Tools and open the Home tab.
- In the Align Text area, choose horizontal center alignment and add vertical centering if needed.
This makes header text more suitable for titles and easier to read consistently.
Why is the indentation effect hard to notice?
- Make sure the selected cell contains text.
- Tap Increase Indent and watch for text position changes.
- If the change is still hard to notice, check whether the cell is too wide or the text is too short.
The visible indentation effect depends on cell width and text length. A narrower column or longer text can make the change easier to see.
Glossary
| Term | Definition |
|---|---|
| Horizontal alignment | The way text is arranged from left to right inside a cell, such as left, center, or right alignment. |
| Vertical alignment | The way text is arranged from top to bottom inside a cell, such as top, middle, or bottom alignment. |
| Indentation | The inward offset of text from the cell boundary, often used to show hierarchy or improve layout. |