See what Chip Pearson has to say about relative and absolute cell references
http://www.cpearson.com/excel/relative.htm

"drandall" wrote:

When I insert a new row, I would like to keep the formula in a cell from
moving down. I believe I used to use the $ sign around the cell in the
formula, but this no longer works with 2003.