Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Auto numbering rows

Amina

My first row is listed as 2 and not 1. Did I need to make the starting number as 0 (zero) and not one as assumed?

Comments

Abdul Khan

Hi Amina,

If your first row is at 2 and you want it to auto number it as 1, you can do so in column properties starting number 1, it does not matter what row you are at, you can start 1 or any number at any row.

Hope this helps.

Thanks

A Khan

JohnHinkle

The order is based on the order in which the rows were added to the sheet. It sounds like the the autonumber may have been applied then the rows moved or a row was inserted above the first row.

Just readd the auto number and set it to start at 1.