Use no reference in the function. In A3 enter:

=ROW()-2 and copy down
--
Gary''s Student - gsnu200765


"Richard" wrote:

I need to automatically number rows in a spreadsheet. I've tried the ROW
function but unless I start at Row 1 and then need to remove a row in the
middle of the spreadsheet I get a #REF error. How can I start row numbering
in Cell A3 and if I need to delete a row somewhere in the spreadsheet have it
automatically adjust?