I can reproduce this behavior in Excel, it seems this is by design behavior.
If you have any feedback or suggestion about this behavior, you can try to give a feedback to Microsoft about your requirement:
Microsoft values your opinion. Your feedback goes directly to our engineers and helps us shape the future of Microsoft products and services for all our users.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.