How to globally change "use header names as labels" in a Numbers document
In the Numbers preferences there is an option to use either cell designations (like "B2") or cell names ("Name2") in formulas.
But there is no way to toggle from using all one style to using all the other style.
I started a document using cell names in formulas, realized my error, then switched to cell designations, so now I have half the document formulas using cell names, half using designations.
Is there some way to globally change all cell references from one to the other?
And before you say "go to preferences and untoggle the "cell references" check box, I've done that like a dozen times. It's probably yet another bug, but maybe there's a way to "select all" then toggle?
Thanks,
Number 3.6.2, OS 10.11.6