View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jensenf
 
Posts: n/a
Default how do I automatically number cells

Starting in cell A2 and all the way down, how do you put in a formula so the
cells are numbered automatically? 1,2,3, etc. and if you delete cell 4, for
example you can reconfigure it so it'll number it again. I tried =row()
function but when I drag the formula down, it keeps the numbers the same.