Purchase numbers

Resolved · Low Priority · Version 2010

Wed 9 Jul 2014, 13:15 Delegate Jay said...

Jay has attended:
Excel Intermediate course
Excel Advanced course

Purchase numbers

say you was buying items and you wanted to give each one a purchase number in order or entering a new item
so lets say you had entered in 1-9 purchase numbers in so:
1 fred
2 fred
3 fred
4 fred
5 fred
6 fred
7 fred
8 fred
9 fred

i want it so when i filled in number 9 number 10 appeared
so it would look like

1 fred
2 fred
3 fred
4 fred
5 fred
6 fred
7 fred
8 fred
9 fred
10

if i started to enter in fred on 10 then a 11 would appear like :

1 fred
2 fred
3 fred
4 fred
5 fred
6 fred
7 fred
8 fred
9 fred
10 f
11

so therefore i dont have to drag down and it prevents errors
and its allways in order from the last one which before was Blank

regards

Jay

Thu 10 Jul 2014, 12:41 Trainer Gary said...

RE: Purchase numbers

Hi Jay

Thanks for getting in touch. Excel has no built-in ability to create Autonumbers. Any solution will be formula-driven and require dragging down. Here are some suggestions:

http://superuser.com/questions/130274/autonumbering-a-column-in-excel

One way to avoid dragging down would be to convert the data into a Table (Home > Format as Table) but there may be some other properties of the table you don't want (such as formatting or structured reference formulas).

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 10 Jul 2014, 12:48 Delegate Jay said...

RE: Purchase numbers

thanks

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips