I'm working in Excel 2003. I have numbers in Columns A and B. In column C i
have a formula that looks like this: =A1+B1 which give me the total for
those cells. however, sometimes i need to insert a cell and I shift the
others down which then changes my formula to: =A1+B2 and I dont want that to
happen. I would like the formula to pick up the value in the new inserted
cell. I have tried making the formula absolute however that does not work.

Please Help!!!!