Merged cells break sorting and tables—use a macro to apply Center Across Selection with one click instead.
When you digitally sign an Excel macro using Visual Basic Editor, you add a unique, encrypted signature to your VBA project.
Sure, it could be fixed. But it's a lot easier to let the false 1900 leap year live on in Excel.