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

Numbers cell name

How to name cell and then use

iPad Pro Wi-Fi + Cellular, iOS 10.3.2

Posted on Mar 1, 2018 2:35 AM

Reply
Question marked as Best reply

Posted on Mar 17, 2018 5:09 AM

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.

2 replies
Question marked as Best reply

Mar 17, 2018 5:09 AM 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 2, 2018 6:49 AM 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

Numbers cell name

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.