How to create a custom list for sorting and filing data in a spreadsheet
This Mhelp clip will show you how to create a custom list that can be used for sorting and filing data.
This Mhelp clip has nine steps.
1 - Click the Office button. A menu will appear.
2 - Click Excel Options. A dialog box will appear.
3 - Click the Popular tab.
4 - Click Edit Custom Lists A dialog box will appear.
5 - Under Custom Lists, click NEW LIST.
6 - Under List entries, type the list of entries to use.
7 - Click Add.
8 - Click OK.
9 - Click OK again to return to Excel.
This concludes the Mhelp clip.