An example with Defined Table - Serie number is added automatically whenewer a new row is added. When any rows are deleted from table, Serie numbering is corrected automatically so numbers are alwais continuous.

To add rows into table, you


a) press Tab key with righmost field in last row active;
b) type info into any cell immediately below last row of Table, assured Table column doesn't contain formula;
c) insert a full row anywhere in Table's datarange;
d) select any cell of Table, and from Design menu click on Resize button. Enlarge the number of Table rows.

Attached Files

SerieNo.xlsx (9.2 KB, 8 views)

Why did you add "blue" to your attachments? My question is not for colors. I am asking how to add dot after numbering series?