Feature Summary
The alignment feature supports setting the horizontal and vertical alignment of cell content, ensuring data is arranged neatly and uniformly.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Steps
Set Horizontal Alignment
Feature Entry
"Home" tab → "Alignment" group
- Select the cell or range where you want to set alignment
- In the "Home" tab, within the "Alignment" feature group, click the corresponding horizontal alignment button
- Options: Align Left, Center, Align Right
Set Vertical Alignment
Feature Entry
"Home" tab → "vertical alignment" group
- Select the cell range you want to set
- In the "home" tab, click the vertical alignment button
- Options: Align Top, Middle Align, Align Bottom. Middle Align is recommended when the cell height is large
More Alignment Settings
Right-click → "Format Cells" → "Font"
- Select the target cell range, right-click to bring up the context menu
- In the context menu, select "Format Cells" to bring up the panel on the right side of the screen
- Switch to the "Text" tab, and choose the desired alignment under "Horizontal Alignment" and "Vertical Alignment"
- "Horizontal Alignment": Options: Align Left, Center, Align Right, Justify, Distributed, Fill, Center Across Selection. Set text indentation in "Indent".
- "Vertical Alignment": Options: Align Top, Middle Align, Align Bottom, Justify, Distributed.
- Preview the effect in real-time in the sheet, and click the editing area to apply
FAQ
Q1: The text is set to center but appears left-aligned?
- Solution: Confirm that both horizontal and vertical alignment are set to center. For single-line text, vertical alignment can also affect the display position and needs to be adjusted simultaneously.
Q2: Why is the text not centered even though centering is set?
- Solution: Check if there is any paragraph indentation setting, as indentation can affect the alignment effect.
Q3: The default alignment for numbers and text is different. Can they be unified?
- Solution: Numbers default to right alignment and text defaults to left alignment. You can unify the format by forcing alignment. Select the entire area and click the desired alignment method.
Notes
- Number cells default to right alignment for easier numerical comparison; text defaults to left alignment
- Alignment of merged cells will simultaneously affect all merged areas
- Alignment settings do not affect the actual cell content, only the display position