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.