Copying and pasting a formula 2

[Pappykahn]

How do you copy and past a formula without it changing? If I copy =sum(A32/30)and past it into the cell directly below it changes to +sum(A33/30) If I have a number of cells to past this in, its a pain changing each one back to A32.

 

[KenWright]

A reference is divided into two parts - A Column reference and a Row reference, eg A1. Use $ signs to lock any part, eg

$A1
A$1
$A$1

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------