View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nathan Elphick Nathan Elphick is offline
external usenet poster
 
Posts: 6
Default Auto Numbers in cells

I want to set up a template with numbers, say 1 - 10 in alternate cells, say
A1, A3, A5 - A19 so that if you add/or delete a row the numbered cell is
added or deleted automatically thus the numbers always remain in numerical
order. Can this be done?