The button allows you to center information contained in a single cell across a range of cells. For the effect you are intending try selecting the cells then going to Format> Cells - Alignment to select Center Across Selection from the Horizontal alignment dropdown. The Merge and Center toolbar button in Excel provides a level of functionality that is very similar to the functionality provided by the 'Center Across Columns' toolbar button in versions of Microsoft Excel earlier than Excel 97.

In the Horizontal list, click Center Across Selection.

The button allows you to center information contained in a single cell across a range of cells.

Right-click the selected cells, and then click Format Cells. The Merge and Center toolbar button in Excel provides a level of functionality that is very similar to the functionality provided by the 'Center Across Columns' toolbar button in versions of Microsoft Excel earlier than Excel 97.

Other cells in the same sheet act normally. Some of my cells will not respond when I apply centering, either with the centering icon or the Format Cells Alignment Horizontal Center. Select the range of cells over which you want to center text. Excel: Some Cells In Sheet WonвЂ™t Center When Directed To.WorkaroundДЄlthough the Center Across Columns toolbar button is no longer available, you can still center text across columns without merging cells. For IBPS PO, IBPS Clerk, SBI PO, SBI clerk and other banking exams. MS Excel are always important for the banking examinations. In Microsoft Office Excel 2007, a Center Across Columns button does not appear on the Home tab. MS Excel MCQ Questions and Answers based on the computer basics. In Microsoft Excel 2000, in Microsoft Excel 2002, and in Microsoft Office Excel 2003, the Center Across Columns button does not appear on the Formatting toolbar. For more information about this change, read this blog post.

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise.

Merge and center in excel not working