Making a cell reference in a formula locked when copying to new cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lionel B. Dyck - 17 Oct 2004 18:37 GMT

Is there anyway to make a cell reference in a formula be locked so that
it is not changed when copying the formula to other cells?

For example in cell E1 =sum(A1+B1+C1) and when it is copied to E2 it is
changed to =sum(A1+B1+C1). I want the reference to C1 to remain the same
(this is a very simple example).

Can this be done?

thanks

Signature

Lionel B. Dyck <><
Homepage http://www.lbdsoftware.com
(remove the x- and -x to contact me directly)

Reply to this Message

Frank Kabel - 17 Oct 2004 18:50 GMT

Hi
use
=SUM(A1+B1+$C$1)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Is there anyway to make a cell reference in a formula be locked so that
> it is not changed when copying the formula to other cells?
[quoted text clipped - 11 lines]
> Homepage http://www.lbdsoftware.com
> (remove the x- and -x to contact me directly)

Reply to this Message

Trevor Shuttleworth - 17 Oct 2004 18:52 GMT

Lionel

Use:

E1 = A1+B1+$C$1

Read about Absolute references in the Excel Help

Note that you don't need "SUM"

Regards

Trevor

> Is there anyway to make a cell reference in a formula be locked so that it
> is not changed when copying the formula to other cells?
[quoted text clipped - 6 lines]
>
> thanks

Reply to this Message

Lionel B. Dyck - 19 Oct 2004 01:29 GMT

Thanks to both excellent suggestions.

Signature

Lionel B. Dyck <><
Homepage http://www.lbdsoftware.com
(remove the x- and -x to contact me directly)

Reply to this Message