Forum Discussion
Turning off the array feature in Exel Office 365
I teach beginning Excel at Lane Community College. When I go to teach them named cells and ranges and how to use them in functions, my students are getting automatic arrays set around their functions...
To my knowledge dynamic array can't be switched on/off, at least without hacking an application. On the other hand, named ranges shall work correctly if not to rely on silent implicit intersection.