View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Arthign Arthign is offline
external usenet poster
 
Posts: 1
Default How do I number sequentially omiting the headings in excel?

Hi,

I know I can number sequentially by just entering 1 in the first row and
hitting ctrl+draging it down. But what if there are headings inbetween that I
want to omit.
Alos I want it to automatically update if i delete a row or add one.
Thanks
Arthi