reference to a specific cell

[mel]

probably simple but i can't get it to work exactly like i
want.

i want to put a number or percentage in a specific cell,
name the cell, and use that cell in a formula. Everytime
I try it moves down a cell and does not refer to the
specific cell that i want.

would someone please email me the proper way? Many
thanks.

 

[Debra Dalgleish]

To name a cell:

1. Select the cell to be named
2. Click in the Name box, to the left of the formula bar
3. Type a one-word name for the list, e.g. TaxRate.
There are some rules for names -- the first character must be
a letter or underscore, and the name can't be the same as a
cell reference. For more information, look in Excel's help,
under "About labels and names in formulas"
4. Press the Enter key.

It's easy to forget step 4, and then the naming is completed. Maybe
that's what is happening in your worksheet.

To use the name in a formula, type the name, or click on the named cell:
=B7 * TaxRate

 

[Gord Dibben]

Mel

As an alternative, don't name the cell, just change it from Relative to
Absolute reference.

i.e. instead of A1 use $A$1. It will not change as it is copied down.

To change hit F2 then highlight the reference in the formula bar and hit F4 to
cycle through the options.

Gord Dibben Excel MVP - XL97 SR2 & XL2002