how to define range names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do name cells so that I can see what the formula is calculating?
Such as A1 * B1 = Final Price
where A1 is price and B1 is discount
so it reads in the final price cell as price * discount
thanks in advance,
A
 
One quick way is to use the namebox
(the droplist box just to the left of the "=" sign)

In Sheet1, say:
Select A1, then click inside the namebox,
and type the name: price, then press ENTER

Repeat to name cell B1 as: discount

Then we could put in say C1: = price*discount

The other (perhaps more proper?) way is to
click Insert > Name > Define,
where the options to add / delete names lie

In the Define Name dialog:
--------------
Under "Names in workbook:"
we could type the name: price
and under the "Refers to:" box,
put: =Sheet1!$A$1
(or just click inside the "Refers to:" box,
clear whatever's there,
then click outside to select A1)
Click OK (or click Add to add another name)

And to paste the list of names created for reference,
in an empty col, click: Insert > Name > Paste > Paste List
 
Back
Top