How to use Custom Lists to fill range in Excel
If you create a custom list in Excel, you can easily fill a range with your own list of departments, clients, cities, credit card numbers, etc. This can save time and reduce errors. First, we will look at an example of a built-in list. 1. Type Sun into cell B2. 2. Select cell B2, click on the lower …