purchase numbers

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Purchase numbers

Purchase numbers

resolvedResolved · Low Priority · Version 2010

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

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

RE: Purchase numbers

thanks


 

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


Server loaded in 0.08 secs.