Welcome!
As MS Office/Excel is not an Apple product and there are not as many Office users active here as one would think, I believe you will be better served by asking in Microsoft's Office forums. MS Office questions posted in these forums tend to linger a long time before getting any kind of helpful response.
MS made their forums less user-friendly than before by making it harder to limit answers to Mac subjects, but it can be done when you know the trick.
Start here:
Results in Office - Microsoft Community.
That will display this page header:

1) Use the “Office Topic” pull-down to select your Office app.
2) Limit answers to Mac topics with the “Office Sub-topic” pull-down.
3) If needed, use the “Show Filters” option to further narrow the results.
Everyone there is both an Office user and a Mac user, something you can't say about Apple's forums. I believe you will find the contributors there knowledgeable and very helpful.
When you post there, by certain you provide them with the version of Office you are using and the macOS version you are running. The more info you provide "up front," the faster you will get useable suggestions.