Excel.Tips.Net ExcelTips (Menu Interface)

Generating Unique Sequential Numbers

Sometimes you may need Excel to generate a unique sequential number. For instance, you could be using Excel to create your invoices or statements, and you need an invoice or statement number that hasn't been used before. This, of course, implies that Excel needs to remember the number from one session to the next.

If you need to use Excel in this way, consider downloading the following free template file:


Offered by the folks at OzGrid, this is a zipped Excel template that will increment an invoice number every time it is opened. Any workbooks created from the template will have a new invoice number that is unique for that workbook (and will not later change).

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1965) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Related Tips:

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

Surendera M. Bhanot    03 Apr 2015, 11:23
Is there any way to create Unique sequential number per row (as possible in Access)?

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.