Thread: Auto Numbering
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Auto Numbering

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?