3-2: Use AutoComplete, Pick from Drop Down List and Fill Down features
Excel's Autocomplete, Pick from Drop Down List and Fill Down features can save a lot of time when entering repetitive data in lists.
This lesson explains how these features work and demonstrates them in action.
As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson.
⌚ Timestamps
0:00 Sample file download instructions, download link, and discussion of sample file.
0:13 The AutoComplete feature in action.
1:07 The Fill Down feature in action.
2:04 "Pick from drop down list" feature in action. Lists all unique items in the list above.