Lists In MS Excel
Excel has lists?
Yes, it does. (And fortunately they’re not “to do” lists!)
Have you ever noticed that when you type “Monday” in a cell and then use the fill handle (the little box in the lower right corner of the cell highlight) to drag down you get the rest of the days of the week?
Usually the fill handle will copy data if there’s only one entry—this time it didn’t. What’s going on here?
Well—the short answer is that the days of the week are in a custom list.
So, what’s a list?
I think a pretty basic answer to that would be that it’s a set of data that have been designated as belonging together for one reason or another.
Obviously, the days of the week or months of the year would qualify. But there are probably sets of information you find yourself constantly entering, such as a list of names, part numbers, company departments, etc.
Wouldn’t it be nice to have these in a list?
Imagine—instead of typing all the items, or copy/pasting them from somewhere else, you could simply type in one and then use the fill handle to have Excel put in the rest.
Seem too good to be true?
Well, this time it’s not.