Alternative to "Merge and Centre"

Hello Michael,

Thanks for your question on using an alternative to 'Merge and Center'. All you have to do is enter the data into a single cell. Select that cell and whatever other cells you need and then from the Home ribbon click the right-hand corner drop down button in the 'Alignment' group. In the Horizontal Text Alignment drop down select 'Center Across Selection'.

This will now look as if you have used Merge and Center

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer