What is the use of custom list in Excel?
Do you have a list of entries you use frequently in Excel? Sick of having to type them in or copy and paste from another workbook? What if I told you that you could save these entries as a custom list in Excel? What if you could use the AutoFill tool whenever you wanted to add them to your worksheet? If you arent familiar with the AutoFill tool then I recommend you check out my post on how to use the AutoFill tool in Excel. If you are familiar with AutoFill then you may know that AutoFill can replicate patterns such as the days of the week and months of the year. Type any day or month into a cell and use the AutoFill tool to produce the remainder of the pattern. A huge time saver for many. As an extension to creating the days and months, you can also set up your own custom lists. The list is then available to be completed using AutoFill in any workbook/worksheet. This works wonderfully for lists such as staff names, departments, product lists, inventory lists and much more. Lets get startedLets take a look at how to set up a custom list and use AutoFill to enter those lists into a worksheet.
Edit a custom listIf you need to edit any entries within a custom list, follow these steps:
Delete a custom listIf you no longer need a custom list, you can easily delete it from Excel.
Custom lists are a great time-saving feature of Excel. They provide a great way to be able to reuse information which you deal with on a regular basis. Comment below if youve found a unique way of using custom lists in your workbooks. |