Excel Custom Lists

Excel’s AutoFill feature is a great timesaver to create series of numbers or lists of days/months.  Even better though is the ability to create your own series of values, e.g. a list of departments or branches of the company.

  1. Select File | Options | Advanced
  2. Scroll to the General section | select Edit Custom Lists1
  3. Select NEW LIST in Custom lists
  4. Enter first series value | select Enter | repeat for whole list2
  5. Once complete select Add | OK3

4

 

Invercargill

64 Arena Avenue, Unit 5

Phone: 03 214 2323

Dunedin

Level 3 Queens Building 109 Princes Street

Phone: 03 474 9943

Locations

New Plymouth
Wellington
Christchurch