Feature Summary

The alignment and indentation feature is used to control the horizontal and vertical alignment of cell content, as well as text indentation, making the spreadsheet layout neater and more visually appealing.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Steps

Align Top

Feature Entry
"Home" tab → "Align Top" option

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the "Align Top" button in the Home tab

截图

Align Middle

Feature Entry
"Home" tab → "Align Middle" option

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the "Align Middle" button in the Home tab

截图

Align Bottom

Feature Entry
"Home" tab → "Align Bottom" option

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the "Align Bottom" button in the Home tab

截图

Align Left

Feature Entry
"Home" tab → "Align Left" option

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the "Align Left" button in the Home tab

截图

Center

Feature Entry
"Home" tab → "Center" option

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the "Center" button in the Home tab

截图

Align Right

Feature Entry
"Home" tab → "Align Right" option

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the "Align Right" button in the Home tab

截图

Justify

Feature Entry
"Home" tab → "Justify" option

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the "Justify" button in the Home tab

截图

Distributed

Feature Entry
"Home" tab → "Distributed" option

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the "Distributed" button in the Home tab

截图

Set Horizontal Alignment via Format Cells Dialog

Feature Entry
"Home" tab → "Format Cells: Alignment" arrow icon → "Horizontal" drop-down menu

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the Format Cells: Alignment arrow icon in the Home tab
  3. In the pop-up dialog, click the "Horizontal" drop-down menu
  4. After selecting the alignment, click OK

截图

Set Vertical Alignment via Format Cells Dialog

Feature Entry
"Home" tab → "Format Cells: Alignment" arrow icon → "Vertical" drop-down menu

  1. Select the cell or part of the text within the cell that needs alignment
  2. Click the Format Cells: Alignment arrow icon in the Home tab
  3. In the pop-up dialog, click the "Vertical" drop-down menu
  4. After selecting the alignment, click OK

截图

Set Horizontal Alignment via Right-Click Format Cells

Feature Entry
Right-click menu → "Format Cells" button → "Alignment" tab1. Select the target cell, right-click and choose the Format Cells button

  1. Switch to the "Alignment" tab
  2. Click the "Horizontal Alignment" drop-down menu
  3. After selecting the alignment method, click OK

截图

Right-click Format Cells to set vertical alignment

Feature Entry
Right-click menu → "Format Cells" button → "Alignment" tab

  1. Select the target cell, right-click and choose the Format Cells button
  2. Switch to the "Alignment" tab
  3. Click the "Vertical Alignment" drop-down menu
  4. After selecting the alignment method, click OK

截图

Decrease Indent

Feature Entry
"Home" tab → "Decrease Indent"

  1. Select the cell(s) for which you want to set indentation
  2. Click the "Decrease Indent" button in the Home tab to adjust the indent level

截图

Increase Indent

Feature Entry
"Home" tab → "Increase Indent"

  1. Select the cell(s) for which you want to set indentation
  2. Click the "Increase Indent" button in the Home tab to adjust the indent level

截图

Set indent level via the Format Cells dialog

Feature Entry
"Home" tab → "Format Cells: Alignment" arrow icon → "Indent" text box

  1. Select the cell(s) for which you want to set indentation
  2. Click the Format Cells: Alignment arrow icon in the Home tab
  3. In the pop-up dialog, locate the "Indent" text box
  4. Enter the indent value, or click the arrows on the right to decrease or increase the indent, then click OK to complete the setting

截图

Right-click Format Cells to set indent level

Feature Entry
Right-click menu → "Format Cells" button → "Alignment" tab

  1. Select the target cell, right-click and choose the Format Cells button
  2. Switch to the Alignment tab
  3. Locate the "Indent" text box
  4. Enter the indent value, or click the arrows on the right to decrease or increase the indent, then click OK to complete the setting

截图