I would like to use cell A1 as a constant for use on formulas. When I
copy and paste the formula down column C, it no longer points to A1.
Any way to assign A1 a variable name for use in formulas?

Two ways you can do this.

1. Make it absolute in the formula like the following $A$1. Example =$A$1

2. Name the cell.
In xl2007 Select the cell and then the Formulas ribbon and then Define Name
(In the middle of the Formulas ribbon)

Pre xl2007 Select the cell then menu item Insert - Name - Define.

Use your chosen name for the cell like MyConstant. (Avoid reserved words
that are used for formulas etc.)

Use the name in formulas like =MyConstant in lieu of =A1

--
Regards,

OssieMac


"Fan924" wrote:

I would like to use cell A1 as a constant for use on formulas. When I
copy and paste the formula down column C, it no longer points to A1.
Any way to assign A1 a variable name for use in formulas?

change your formula notation for A1 to $A$1

See help file
Switch between relative, absolute, and mixed references


Reference (Description) Changes to
$A$1 (absolute (absolute cell reference: In a formula, the exact
address of a cell, regardless of the position of the cell that contains
the formula. An absolute cell reference takes the form $A$1.) column and
absolute row) $A$1
A$1 (relative (relative reference: In a formula, the address of a cell
based on the relative position of the cell that contains the formula and
the cell referred to. If you copy the formula, the reference
automatically adjusts. A relative reference takes the form A1.) column
and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3


--
mudraker

If my reply has assisted or failed to assist you I welcome your
Feedback.

www.thecodecage.com
------------------------------------------------------------------------
mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68908

A little extra information on absolute addressing. You can place the $ sign
just in front of the column like this $A1 and then you can copy the formula
right across to any column and it will always address column A. However, when
you copy the formula down in the other columns, while it always addresses
column A you will find that the row number changes.

The above is handy to know if you have a value that is always in column A
for the formulas across the worksheet but it is a different value for each
row.

The same with the row numbers. You can use A$1 and copy a formula down and
it will always address row 1. If you copy the formula across then the column
id changes but it will still always address row 1.

Hope this little bit of info helps.

--
Regards,

OssieMac


"OssieMac" wrote:

Two ways you can do this.

1. Make it absolute in the formula like the following $A$1. Example =$A$1

2. Name the cell.
In xl2007 Select the cell and then the Formulas ribbon and then Define Name
(In the middle of the Formulas ribbon)

Pre xl2007 Select the cell then menu item Insert - Name - Define.

Use your chosen name for the cell like MyConstant. (Avoid reserved words
that are used for formulas etc.)

Use the name in formulas like =MyConstant in lieu of =A1

--
Regards,

OssieMac


"Fan924" wrote:

I would like to use cell A1 as a constant for use on formulas. When I
copy and paste the formula down column C, it no longer points to A1.
Any way to assign A1 a variable name for use in formulas?

Nice! And so simple.Thanks.