The Merge cells format has lots of issues. It can crash macros and stop you copying and pasting.

In less than a minute you can use a macro to solve the problem.

Center Across Selection takes a few mouse click to apply but it doesn’t have the issues Merge cells does.

A macro can do it much quicker – see how in this quick video.