A user-defined sequence of data used for consistent sorting and AutoFill operations.
AI로 사용해 보기A Custom List is a saved series of items, such as department names or product categories, that Excel recognizes for non-alphabetical sorting and sequential AutoFill. By creating these lists, users can drag the fill handle to populate cells in a specific order rather than relying on standard alphabetical or numerical patterns.
Creating a list like 'Low, Medium, High' allows you to sort tasks by priority rather than alphabetically.
Go to File > Options > Advanced, scroll down to the General section, and click 'Edit Custom Lists'.