| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tools Options Custom Lists
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tools Options Custom Lists
Hello
Custom lists allows you to create personnal (custom) list items which you can then increment in a worksheet. Say for example you create a list of towns and sort them alphabetically, when you input one item in a cell and drag the cell down, Excel will automatically fill in with the following items in the list. Hope this helps Cordially Pascal "starguy" a écrit dans le message de news: ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tools Options Custom Lists
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tools Options Custom Lists
thank you both. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=533645 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| options custom list | Excel Worksheet Functions | |||
| How do I add custom colors to pallet | Setting up and Configuration of Excel | |||
| Using custom functions within custom validation | Excel Discussion (Misc queries) | |||
| Custom Views in Shared workbook | Excel Discussion (Misc queries) | |||
| Custom list - how to include commas? | Setting up and Configuration of Excel | |||
Hybrid Mode
