I want to do something that seems very simple, but I can't work out how. I have a column with different numbers in each cell (actually coordinates). I want to create a second column by adding the same number to each cell in the first column. I can create a function to do this, but only by typing it in each cell in the second column - and I have hundreds to do. I thought of adding an intermediate column filled with the number to be added, then doing autosum across each row, created the results column - still doing it row by row, but much quicker. This works at first but as soon as you have done two rows, autosum defaults to adding the numbers in the results column, rather than adding across the row. There is probably a really simple solution to automating this, but I can't see it.