Custom Lists using Numbers

  • Thread starter Thread starter CY
  • Start date Start date
C

CY

I would like to create a custom list that I can use with AutoFill that
consists of numbers (that are employee numbers) but they are non-sequential,
but I need them in a specific order. E.g. 301,304,306,307,309,314,321, so
that if I type 301 the autofill will continue the list for me. Is this
possible?

TIA.

CY
 
Hi CY
This will not be possible with Autofill because your list is made of
numbers.
An alternative would be to amend your employee numbers so that they become
text e.g. EN301, EN304 and so on.
In which case you could use the Tools, Options, Custom lists feature and
create a new custom list from these entries.
See if this helps.

Cordially
Pascal
 
Choose Tools>Options
Select the Custom Lists tab
In the List Entries box, type your list of numbers in a column
Click OK
 
Back
Top