Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: 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

Posted on

Reply

Page content loaded

Apr 22, 2018 4:52 AM in response to michaelpals In response to michaelpals

Interesting. I have never seen it get stuck halfway. Maybe someone else has seen this. In my experience it either uses the header names or it does not and, if you change the preference, it converts all of them to whichever way you set it. I have Numbers 4.3.1 installed so I cannot check out any problems that might be unique to Numbers 3.6.2.

Apr 22, 2018 4:52 AM

Reply Helpful

Apr 22, 2018 5:59 AM in response to Wayne Contello In response to Wayne Contello

Hi Wayne,


Maybe you missed the part of my post where I said pretty clearly "And before you say "go to preferences and untoggle the "cell references" check box, I've done that like a dozen times." It doesn't work, that's the problem, and I'm seeking help on how to get it to work, is there some kind of document "preference" I can delete or reset?

Apr 22, 2018 5:59 AM

Reply Helpful

Apr 22, 2018 6:48 AM in response to michaelpals In response to michaelpals

Yes. My bad for not reading your post clearly and all the way through.


I suggest starting with a new document and copying the content out to a new document. It may be that Numbers preserves references once they are in the header name format

Apr 22, 2018 6:48 AM

Reply Helpful

Apr 22, 2018 6:58 AM in response to Wayne Contello In response to Wayne Contello

I'm the one who should apologize, I'm just starting to dig deeper into spreadsheets. There was no "error", here's what happened:


When I linked in a formula from one "sheet" to a cell in another "sheet", the formula was showing the "sheet"name, not the cell name. So the formula would look like "(Sheet1B2 + Sheet2B3)". The issue is that the sheet names are so long that they don't fit in the formula window, and I was misinterpreting this as "(CellnameColumn/CellnameRow)".


Problem "solved".

Apr 22, 2018 6:58 AM

Reply Helpful

Apr 22, 2018 9:16 AM in response to michaelpals In response to michaelpals

Hi Michael,

The issue is that the sheet names are so long that they don't fit in the formula window

You can enlarge the formula edit box by hovering the cursor over any edge of the box until it shows a "north-south" or an "east-west" enlargement cursor.

User uploaded file

Regards,

Ian.

Apr 22, 2018 9:16 AM

Reply Helpful
User profile for user: michaelpals

Question: How to globally change "use header names as labels" in a Numbers document