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

  • Thread starter Thread starter Lionel B. Dyck
  • Start date Start date
L

Lionel B. Dyck

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
 
Lionel

Use:

E1 = A1+B1+$C$1

Read about Absolute references in the Excel Help

Note that you don't need "SUM"

Regards

Trevor
 
Back
Top