98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Purchase numbers
Purchase numbers
Resolved · Low Priority · Version 2010
Wed 9 Jul 2014, 13:15Delegate 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:41Trainer 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Highlighting a data rangeAttempting 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! |
