Feb 20 2022 09:04 AM
Feb 20 2022 09:15 AM
It very depends on how you formulas are relay on implicit intersection. Please check here Implicit intersection operator: @ (microsoft.com)
Feb 20 2022 10:21 AM
Feb 20 2022 02:04 PM
Sorry, but if you want Excel to behave like old Excel, reinstall a legacy version of Excel; 2010 worked OK. The point of modern Excel is that it allows you to work in a different manner with dynamic arrays in place of single cell relative references. The differences are profound and the experience will be more rewarding if you embrace the change rather than forever harking back to how you would have done it.