Center Across Selection

Center Across Selection - This allows you to centre text across a selection of cells, without the disadvantages of actually merging the cells.
The text has been entered in cell B2, and then centred across the cell range "B2:F2".
Enter the text in the left most column. Select the cells that you were going to merge and apply this format.
This is preferred to Merging the cells since you can still cut or copy the rows or columns that intersect with it.

microsoft excel docs

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext