I do NOT believe it does this. To the best of my knowledge, you have to write a function that rewrites that entire column every time the page loads Hmmm... I wonder if it could be done based on the line number. That way you could write a single formula that does a comparison to the line it's on and does a recalculation every time a row is added. (you would of course have to copy the formula to the new row.) By the way, =row(A1) will return the row number for row 1, so your row numbers don't have to start at row 1, If you put row(A1) into row 10, it would still return a 1. Every subsequent change you made after would have the formulae readjusted for every insertion.