Forum Discussion
Spill Arrays and Named Variables
Does anyone else hate the new spill arrays? It does not work well with named cells. At least for me, since many, if not all, of my names are arrays. Is there a way to turn this "feature" off?
No you cannot turn them off. To make the names work the same as previously, prepend each name with the @ character:
=@Sales-@Cost
The @ character forces Excel to use a feature you've been using without knowing called implicit intersection. It takes the value from the name on the same row (or column).
Alternatively, you can use =Sales-Cost in the top-left cell only and it'll fill all by itself.
=@Sales-@Cost
The @ character forces Excel to use a feature you've been using without knowing called implicit intersection. It takes the value from the name on the same row (or column).
Alternatively, you can use =Sales-Cost in the top-left cell only and it'll fill all by itself.