跨列居中^{(Center Across Columns)}工具栏按钮在Microsoft Excel中不再可见。它已被提供相同功能的Merge 和 Center所取代。^{(Merge and Center)}顾名思义，它允许用户将包含在单个单元格或一系列单元格中的信息居中，但有时该按钮可能无法出现在功能区菜单下。当“合并和居中^{(Merge and Center)}”按钮未出现在Excel工具栏上时，您应该执行以下操作以使文本居中。

缺少合并和居中按钮

当合并^(Merge)和中心按钮丢失、灰显或在^(Center)Excel中不起作用时，有两种可能性。首先^(First)，您的工作表受到保护。其次^(Second)，工作簿^(Workbook)是共享的。因此，如果您在启用共享时关闭共享，则该按钮应该再次可用。如果这不起作用，请尝试以下解决方法！

1. 选择要居中的单元格。
2. 右键单击并选择“设置单元格格^{(Format Cells)}式”选项。
3. 选择对齐^(Alignment)选项卡。
4. 单击水平^(Horizontal)标题旁边的下拉箭头。
5. 选择跨选区居中^{( Center Across Selection)}。
6. 点击确定^(OK)按钮。

上述解决方法将让用户将包含在单个单元格中的信息集中在一系列单元格中。

打开要编辑的Excel文件。^(Excel)

接下来，选择要使文本居中的单元格范围。

右键单击^{(Right-click)}选定的单元格，然后从显示的选项列表中选择设置单元格格式。^{(Format Cells)}

阅读^(Read)：自定义 Excel 中的快速访问工具栏，使其适合您。

当“设置单元格格^{(Format Cells)}式”窗口打开时，切换到“对齐^(Alignment)”选项卡。

单击对齐^(Alignment)选项卡。

在文本对齐^{(Text alignment)}部分下，转到水平标题。

单击下拉箭头并选择Center Across Selection选项。

完成后，单击确定^(OK)按钮。

您会注意到包含在单个单元格或一系列单元格中的文本将立即居中。

That’s all there is to it!

Merge and Center button is not working, missing, greyed out in Excel

The Center Across Columns toolbar button is no longer visible in Microsoft Excel. It has been replaced by Merge and Center that offers the same functionality. As the name suggests, it lets users center information contained in a single cell or across a range of cells but sometimes the button may fail to appear under the ribbon menu. Here’s what you should do to center texts when the Merge and Center button doesn’t appear on the Excel toolbar.

Merge and Center button is missing

There are two possibilities when the Merge and Center button is missing, greyed out or not working in Excel. First, your worksheet is protected. Second, the Workbook is shared. So, if you turn off sharing when it is enabled, the button should once again be available. If this doesn’t work, try the following workaround!

1. Select cells to be centered.
2. Right-click and choose the Format Cells option.
3. Select the Alignment tab.
4. Click the drop-down arrow adjacent to the Horizontal heading.
5. Choose Center Across Selection.
6. Hit the OK button.

The above workaround will let users center information contained in a single cell across a range of cells.

Open the Excel file you would like to edit.

Next, select the range of cells over which you would like to center text.

Right-click the selected cells, and then choose Format Cells from the list of options displayed.

Read: Customize the Quick Access Toolbar in Excel to make it work for you.

When the Format Cells window opens, switch to the Alignment tab.

Click the Alignment tab.

Under the Text alignment section, go to Horizontal heading.

Click the drop-down arrow and choose the Center Across Selection option.

When done, click the OK button.

You’ll notice that the texts contained in a single cell or a range of cells will be centered, instantly.

That’s all there is to it!

Related posts

• 如何Merge and Unmerge cells在Excel

• 在 Excel 中将您的工作表数据居中以进行打印

• 如何合并多个 Excel 文件中的数据

• 如何在 Excel 中合并单元格、列和行

• 如何在Excel中使用Percentile.Exc function

• 如何在Microsoft Excel中使用MID and MIDB function

• How以使用Excel的Mode function

• Excel，Word or PowerPoint上次无法启动

• Excel中Mean的Calculate Standard Deviation and Standard Error

• 如何在Excel formula中锁定单元格以保护它们

• 如何在Excel创建和使用Form Controls

• 如何在Microsoft Excel中添加或汇总Time

• 如何在Excel中使用DGET function

• 如何在Excel中使用DEC2Bin将十进制数转换为二进制数

• 如何在Excel中使用DISC function

• 如何在Microsoft Excel worksheet中添加Trendline

• 如何修复损坏的Excel Workbook

• 如何在Excel中使用Find and FindB functions

• 如何在Excel中使用CHOOSE function

• 如何在Excel中使用INT and LCM Functions