Naming cell in Numbers
How can a cell in Numbers be named as is done in Excel? e.g. interest_rate
Numbers doesn't have a way to define a specific cell as a named range the way you can do in Excel.
However, in Numbers take advantage of Header Rows and Header Columns. If you have a Header Row in a table, each column automatically takes on the properties similar to named range in Excel. The same goes for a Header Column. Each row takes on the properties similar to a named range.
A simplified example. Suppose you have a table like this and want to calculate the Interest column.
You could enter B2*C2 in cell D2. But you could also type Amount * Interest Rate. Numbers autocompletes for you.
The result looks like this:
But if you prefer the named ranges to show you can go to Numbers > Preferences and check 'Use header names as labels.'
Then the formula looks like this:
And you can refer to the columns in similar fashion.
If you want a one-cell named range to use in formulas, you can set up a table like this:
And refer to that as Rate1 in your formulas.
SG