|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 11:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com