From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Increasing your productivity with custom lists

Increasing your productivity with custom lists - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Increasing your productivity with custom lists

“

- [Instructor] If there's a list of items 2 that you need frequently. 3 For example, here's a list of departments within a company. 4 I frequently need this list, 5 so what have I been doing? 6 I open this file and I copy paste the information. 7 Well, let's suppose I want to have it available 8 at my fingertips at all times. 9 What if I could simply type in any of the entries, 10 say the first one, like ADC here, 11 and then drag from the corner 12 and get all the others automatically. 13 That sure would be great. 14 Can't do it yet. 15 We can do this if we convert the list 16 into what's called a custom list, 17 and we need only do this once. 18 And when we do this, it stays in our Excel settings 19 on this particular computer. 20 It's called a custom list. 21 And there's another use for a custom list, 22 totally different context. 23 I've got a list of entries here 24 that pertains to the order 25 that I'd…

Contents