Thursday, July 10, 2014

Customizing Excel for You!

Excel is very smart.  Occasionally, however, it needs your help in understanding how you want it to work (after all, it can’t read minds or anticipate all needs for all users).

One of the ways that it needs your help is when you have Special List requirements.  As we all know, Excel has several familiar Built-in Lists, such as Sunday-Saturday, Jan-Dec, etc.  Your own user-defined lists can be very practical, however, as they can be used for sorting or Auto-Filling your data.
 
Using Excel 2013 for Illustration, Here is What You Do:

1. Go to File/Options and then click the Advanced option
2. Scroll down to the General category, and click the Edit Custom Lists button
3. In the Custom Lists box, click NEW LIST, and then type the entries in the List entries slot
4. When the list is complete, click Add
5. Click OK


An Easier way, (especially if you are dealing with a larger list), when using the Custom Lists dialogue box, Import it directly from a completed column list:
 
The Bonus in all of this is, of course, is that your Custom Lists are added to your computer's registry, so it is always available for use in other Excel workbooks.

Give it a try sometime.  You may find that Custom Lists will give you a New Ride in Excel!

No comments: