From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Use custom lists for rapid data entry and list-based sorting

Use custom lists for rapid data entry and list-based sorting

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Use custom lists for rapid data entry and list-based sorting

- [Voiceover] We're looking at a work sheet called Autofill, one we've seen in previous movies. But over in column I, and to the right, we see some lists. The list in column I goes all the way down to row 23. 23 different entries there. Also a list over here. And over in column M, we see the alphabet. Now, in Excel you can use what's called a custom list. And you can use it for two major reasons. Here's one thought. I use this data often. I often need this list. Now, you might've seen in an earlier movie how easy it is if you want to put in months and often you start with January, or simply J-A-N, either way. And if you type in any month in the entry, you can drag from the corner once you've started the entry, and get next month, next month, next month. Wouldn't it be great if on any worksheet, because you need this list, what if you could type ADC and drag from the corner and get all these others? Now, the other list to the right may be not so obvious, we'll get to those momentarily.…

Contents