Cell Formatting

[Guest]

I am trying to take and copy a format in a cell to another cell, but when I
do that it want to change the vaules to include the cell next to it.
Example:
Cell D5 =A1+B1+C75
when I copy & paste in D6 I get =A2+B2+C76
I want D6 to be =A2+B2+C75

How can I do this?

 

[JE McGimpsey]

Take a look at "The difference between relative and absolute references"
in XL Help:


Then try: =A1 + B1 + $C$75