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

Question:

Question: Numbers cell name

How to name cell and then use

iPad Pro Wi-Fi + Cellular, iOS 10.3.2

Posted on

Reply
Question marked as Helpful

Mar 17, 2018 5:09 AM in response to AlanPike In response to AlanPike

In Numbers/Preferences, make sure you have "use header names as labels" turned on.


Your table must contain a header column and a header row for a cell to get a "name". The name will be whatever is in the column header cell, a space, then whatever is in the row header. For example, if B1="Alan" and A2="Pike", cell B2 will get the name "Alan Pike". You can type it into formulas (you will need to type the space also) or, if you refer to it in a formula as B2, it will get automatically converted into the name. In addition to the cell getting a name, the entire column will be referred to as "Alan" and the row as "Pike". You can use those in formulas, too.

There’s more to the conversation

Read all replies
Question marked as Helpful

Mar 17, 2018 5:09 AM in response to AlanPike In response to AlanPike

In Numbers/Preferences, make sure you have "use header names as labels" turned on.


Your table must contain a header column and a header row for a cell to get a "name". The name will be whatever is in the column header cell, a space, then whatever is in the row header. For example, if B1="Alan" and A2="Pike", cell B2 will get the name "Alan Pike". You can type it into formulas (you will need to type the space also) or, if you refer to it in a formula as B2, it will get automatically converted into the name. In addition to the cell getting a name, the entire column will be referred to as "Alan" and the row as "Pike". You can use those in formulas, too.

Mar 17, 2018 5:09 AM

Reply Helpful (1)

Mar 2, 2018 6:49 AM in response to AlanPike In response to AlanPike

If you are referring to the functionality in excel where you can rename a single cell (or range of cells) anything you want for clarification (e.g. Cell A2 is MASS and G4 is Acceleration so your formula would be =Mass * Acceleration), you cannot do that in numbers.


the closest thing you can do is use named header columns and rows as suggested by Badunit already.


Jason

Mar 2, 2018 6:49 AM

Reply Helpful
User profile for user: AlanPike

Question: Numbers cell name