Providing that the numbering starts from row 1 use the ROW function.
=ROW()



"Arthign" wrote:

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