Edited by author 11-10-2009 01:21 PM
/m2261Jeanette, If I understand your requirement you have a series of coordinates in column A. You want to add a number to each of the cells in column A and place the result in column B. e.g A1 = 10, add 20, B1 = 30; A2 = 5 add 20, B2 = 25
If my example is correct then I would place the number I want to add in a separate cell away from the two columns e.g. C1 then in B1 place the following formula
'A1 + $C$1' then pull down the fill handle in the bottom right corner of B1 to copy the formula down all rows
Now you can change the value of C1 if you wish and recalculate the spreadsheet without having the change any other formulae
