Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Consecutive Numbers in a List.

Status
Not open for further replies.
shannan

shannan

Technical User
Aug 30, 2000
1
US
How do I create a numbered list of consecutive numbers ex. serial numbers KH0001 to KH0201 without typing each individual serial number. At the same time numbering each line.
 
Sort by date Sort by votes
Type KH0001 in A1
Type KH0002 in A2

Highlight A1:A2 and drag the drag handle on the bottom right of A2 down as far as you need.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Wicca
  • Locked
  • Question
MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another
Replies
16
Views
196
Wicca
Wicca
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
remeng
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
981
remeng
remeng
N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
732
SkipVought
S
pendle666
  • Locked
  • Question
Change colour of cells based on dropdown list value in another - Excel professional plus 2016 1
Replies
5
Views
175
pendle666
pendle666

Part and Inventory Search

Sponsor

Back
Top