Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Lists in Excel
I know the default custom lists in Excel are an effort to make life simpler,
but I want to delete them because they are causing other list sorting incorrect. For example, I study car sales, and we have 3 digit names for car makes. Saturn is one of those makes. Your custom list interprets 'SAT' as Saturday and places it on the top of the list. This is a nuisance. Please allow us to override those default lists. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
|
|||
|
|||
Custom Lists in Excel
Even though you can't (easily)remove the default lists, you can do the next
best thing. Go to ToolsOptionsCustom Lists & create your own... even if it includes entries that appear in other lists. Whenever you need to sort, click in the range and go to DataSort, click the Options button, then open the combo box list & choose the Custom sort key you want to use. If you need to use it frequently, just record a simple macro & add it as a custom toolbar button or menu command. Regards |:) "Custom Lists in Excel" wrote: I know the default custom lists in Excel are an effort to make life simpler, but I want to delete them because they are causing other list sorting incorrect. For example, I study car sales, and we have 3 digit names for car makes. Saturn is one of those makes. Your custom list interprets 'SAT' as Saturday and places it on the top of the list. This is a nuisance. Please allow us to override those default lists. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel should have a floating "custom view" toolbar | Excel Worksheet Functions | |||
importing/exporting lists of names/addresses into and out of excel | Excel Discussion (Misc queries) | |||
How do I move excel address lists to outlook. and vice versa. | Excel Discussion (Misc queries) | |||
custom fill problem in Excel 2003? | Excel Discussion (Misc queries) | |||
Enter an Excel cell reference as part of a custom header/footer | Excel Worksheet Functions |