You first need to enter two sequential numbers.Ĭlick on the menu options and choose Fill Without Formatting and any copied cell formatting will be removed. The fill handle will automatically create a sequence of serial numbers for you with just a click and drag. Once you learn it, there is no going back to the old way of manually typing each number of a sequence. You can use these as serial numbers for your data.
On the very left hand side of every sheet is the row heading with row numbers in an incrementally increasing sequence. Good news! Excel comes with serial numbers out of the box. Use the Connection Properties for Connected Tables.
