Excel 简明教程

Text Alignments in Excel 2010

如果不满意单元格的默认对齐方式，可以对单元格的对齐方式进行更改。以下列出了执行此操作的多种方法。

If you don’t like the default alignment of the cell, you can make changes in the alignment of the cell. Below are the various ways of doing it.

Change Alignment from Home Tab

可以更改单元格的水平对齐方式和垂直对齐方式。默认情况下，Excel 将数字右对齐，文本左对齐。单击“开始”选项卡中“对齐”组中可用的选项以更改对齐方式。

You can change the Horizontal and vertical alignment of the cell. By default, Excel aligns numbers to the right and text to the left. Click on the available option in the Alignment group in Home tab to change alignment.

alignment from home

Change Alignment from Format Cells

右键单击单元格并选择“设置单元格格式”。在“设置单元格格式”对话框中，选择 Alignment Tab 。从“垂直对齐”和“水平对齐”选项中选择可用的选项。

Right click on the cell and choose format cell. In format cells dialogue, choose Alignment Tab. Select the available options from the Vertical alignment and Horizontal alignment options.

alignment from format cells

Exploring Alignment Options

1. Horizontal Alignment − 可以将水平对齐方式设为左对齐、居中对齐、右对齐等。

1. Horizontal Alignment − You can set horizontal alignment to Left, Centre, Right, etc.

  1. Left − Aligns the cell contents to the left side of the cell.

  2. Center − Centers the cell contents in the cell.

  3. Right − Aligns the cell contents to the right side of the cell.

  4. Fill − Repeats the contents of the cell until the cell’s width is filled.

  5. Justify − Justifies the text to the left and right of the cell. This option is applicable only if the cell is formatted as wrapped text and uses more than one line.

2. Vertical Alignment − 可以将垂直对齐设置为顶部、中间、底部等。

2. Vertical Alignment − You can set Vertical alignment to top, Middle, bottom, etc.

  1. Top Aligns the cell contents to the top of the cell.

  2. Center Centers the cell contents vertically in the cell.

  3. Bottom Aligns the cell contents to the bottom of the cell.

  4. Justify Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line.