Custom a List in Excel

Phil Matlock

 

If you are like I am and use Excel to create an electronic grade book you may need a custom list from time to time ,like days of the week (Monday Wednesday), that is not built into the regular drag command of Excel. The easiest way to create this list is to create a Custom List using the Options command under the Tools heading at the top of the screen. 

  1. Click the Tool tab at the top of the Excel screen

  2. When the drop down list appears select Options and a new screen will appear

  3. Select the Custom List tab. The “New List” should be highlighted in “Blue” (on the left)

  4. On the right side type in the new series with a comma in between (Monday, Wednesday) and hit the Add button and the new list will be added to the active list (left side)

If you wish to delete just select and click the delete button.

 

Phil Matlock