wallsall

Thanks a lot lads! I've got it now and you been a great help. Wallsall.

Sorry to be so confusing, I will try again. Cell A1 contains the number '10'. Cell A2 contains the number '20'. My formula in cell A3 is '=A2+A1' But if I now scroll down the column the next cell would add A3+A2 and so on. I don't want this, I want each cell to add A1 all the time. Eg: A2+A1 A3+A1 A4+A1 A5+A1 A6+A1 etc etc etc. Hope you can help. Thanks.

Thanks, I just want the cell to have a constant value. For instance I want the cell to have a value of 10 and to remain at 10 when all all cells are referring to it. Wallsall.

In Excel spreadsheet I want to make one cell 'constant'. How is this done please? Thanks. Wallsall.