Hi DrewC_643,
Thanks for posting in the community and sorry for the inconvenience you experienced.
I can reproduce the same situation on my end. I have searched a lot but did not find any official blogs/articles mentioning this change.
I understand the inconvenience this change causes to users in their daily work. Based on my search, here is feedback where members mentioned the same situation. I recommend you vote for this feedback. The Microsoft Feedback Portal is the platform for Microsoft to hear your voice and improve our products. Also, you can send feedback in Excel for Web via the Help tab> Feedback> Report a problem.
Appreciate your understanding and patience.
Sincerely,
George | Microsoft Community Moderator