Can anyone advise me how to number the first column of my worksheet.
I want the number to automatically increment when I enter the first cell of
following row. I do not want this number to be entered manually.
I need to be able to delete rows randomly and for the the row numbers to
automatically renumber in numerical order with no numerical gaps.
For example if I have a column 1,2,3,4,5, and delete 3, I would like the
column to automatically renumber as 1234 and not 1,2,4,5.
I hope I have explained myself correctly. I have a copy of Excel 2002
InsideOut, but can't find a method to do this.
Please supply an example if possible.
I tried =ROW() but cna't get it into all the rows to test if I can maintain
my numerical record numbering when a ROW is deleated.
Please Advise
Thanks
Dermot

Another relevant question...although basic.....
I will try to keep it brief....
I know how to enter the formula in a cell
I could enter the formula in say a group of 20 Cells manually...
I do not know how a shortcut method to enter the formula in all the cells
beyond say row 4 to say infinity.....this would save me the need to return at
a later date to
enter the formula manually every time the rows I have previously entered
enter the formula in run out (Used as a record).
I have tried experimenting with copy and paste but do not get the results I
expected.
Thanks
Dermot