As you've likely discovered the difference between this option and choice #1 is the fact, now, Excel notifies you that a macro continues to be disabled. This can be the default solution in Excel and, as discussed in Excel 2013 VBA and Macros Once you halt dragging, the selected area https://www.customguide.com/excel/how-to-merge-cells-in-excel