It was an example how to get automatic numbering with dot at end. As you provided only a screenshot from middle of nowhere from your worksheet, I had nothing to work with at all. So I created a fake Table to show what you have to do.

You can add any number of rows above Table, so the Table starts e.g. from any row. You can have any info entered into rows at top of Table, assured you leave the row immediately above Table table headers empty. What is entered into Table columns right at serials doesn't count at all - it doesn't affect how serials are calculated.

In case you want the numbering start from some other number (e.g. from 85), you can define a Name (Formulas > Name Manager) like FirstNo with '=85' in Refers to field, and then modify the series formula like
In case you want something different, you have to provide enough information.


What do you mean here? Why odd and even rows are colored differently? This is how defined Table behaves. Blue is default color, but you can select different color schemes when you want - I never bother.

Btw. When I write 'table', then I mean a table you get when you enter some column headers into worksheet, and the you enter some data into those columns below header row. When I write 'Table', then I mean you select any cell of your table, and then you select from menu Insert>Table, confirm that you want to create a Table, and that the Table will have a header row. And preferably you edit the name of Table in some meaningful way - by default Tables are named like Table1, Table2, etc. Later you can access Table properties from Design menu, which is displayed whenever you activate any cell in Table.