A custom list is used to control sorting order when you don't
want the sort to be in alphabetical order. For example, there is
a custom list of month names, so that month names will sort in
calendar, not alphabetical, order. You can create your own lists.
Suppose you have a sales worksheet that lists sales by region,
North, South, East, and West. If you sort on the sales region
column normally, the rows will order by East, North, South, then
West, in alphabetical order. If you want to sort in another
order, you'd create a list like North, South, East, and West,
then instruct the Sort command to use that list. The data will be
sorted in that order.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"starguy"
wrote in message
...

what is the use of custom lists. please any one tell in detail.


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread:
http://www.excelforum.com/showthread...hreadid=533645