Sorry missed the merge question.

if you highlight 2 cells, right click > format cells then in the horizontal alignment drop down you will see 'Center Across Selection'

It looks the same as merge but doesn’t cause any of the downstream problems.

As an example on the attached if you click on column F, you high select column F. if you click on column D you select columns D & E

In my experience Merged Cells is the work of the Devil and i would avoid in all cases!

Attached Files

Merged vs Center accross selection.xlsx (9.7 KB, 7 views)