Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Use Flash Fill in Excel 2013
How to Save Custom Views of an Excel 2013 Worksheet
How to Add Data to Data Lists Using the Excel 2013 Form Button

How to Create Custom AutoFill Lists in Excel 2013

Step 1 of 7
Previous
Next Slideshow
Next Slideshow

Click the cell with the first entry in the custom series and then drag the mouse or Touch pointer through the range until all the cells with entries are selected.

The expanded cell cursor should now include all the cells with entries for the custom list.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Drag and Drop in Excel 2013
How to Customize Excel 2013 AutoCorrect
How to Select Ranges in Excel 2013
How to Edit Cell Content in Excel 2013
How to Add Records to Data Lists via the Data Form in Excel 2013
Advertisement

Inside Dummies.com