Increasing your productivity with custom lists

- If there's a list of items that you need frequently.…For example, here's a list of departments…within the company.…I frequently need this list…so what have I been doing?…I open this file and I copy, paste the information.…Well, let's suppose I wanna have it available…at my fingertips at all times.…What if I could simply type in…any of the entries, say the first one,…like ADC here, and then drag from the corner…and get the others automatically.…That sure would be great.…Can't do it yet.…We can do this if we convert the list…into what's called a custom list.…

And we need only do this once.…And when we do this it stays in our Excel settings…on this particular computer.…It's called a custom list…and there's another use for a custom list.…Totally different context.…I've got a list of entries here…that pertain to the order that I'd like to see…this list sorted by.…In other words, I want to quickly be able…to sort this list based on all the Full Time…people coming first.…Now, if I use an alphabetic sort here…it's gonna sort alphabetically.…