Serial numbers in excel?

Question

I have a table in excel with "serial number" being the first column in it. Is it possible to have excel automatically insert the serial numbers every time I add a new row or data to a new row in the table.


Thanks a million!

Answer 1

A2 =IF(ISBLANK(A2),"",(whatever your first number will be) (row 1 are headers I suspect)

In A3 enter =IF(ISBLANK(B3),"",MAX($A$2:A2)+1) copy this down column as far as is required.

Once you type something into B3 the next number will appear

Answer 2

unsure why you're able to desire to as you are able to in basic terms particularly get admission to the row extensive type, yet you reproduction this formula into column A1, click on A column, and paste. =IF(B1 <> "",ROW(A1),"") this certainly states if column B isn't sparkling, insert the row extensive type in column A. in case you have a header, then =IF(B2 <> "",ROW(A2) - a million,"")...the only distinction right here, previous to copying into the A column is carry the CTRL key and deselect the 1st row.

Answer 3

Yes, just format column as 1,2,3