options dialog

There may be times when you will find it necessary to sort a data list on something other than the alphabet. You can define a custom list of elements on which to base the criteria for a sort. Excel provides a built-in custom sort routine that lists ... months in their chronological order from January to December. Other lists can be created from an existing range of cells or simply entered on the Custom Lists tab of the Options dialog box. Follow the steps below to see how it works: Choose Tools | Options. The Options dialog box opens. Click on the Custom Lists tab. Choose New List in the Custom ... (view more)

There may be times when you will find it necessary to sort a data list on something other than the alphabet. You can define a custom list of elements on which to base the criteria for a sort. Excel provides a built-in custom sort routine that lists ... months in their chronological order from January to December. Other lists can be created from an existing range of cells or simply entered on the Custom Lists tab of the Options dialog box. Follow the steps below to see how it works: Choose Tools | Options. The Options dialog box opens. Click on the Custom Lists tab. Choose New List in the Custom ... (view more)