How to Create a Drop-Down List From a Range of Cells on Another Worksheet. Small businesses need to ensure data integrity in spreadsheets. Microsoft groups objects such as drop-down lists in a ...

Click that text, and a drop-down box will appear with the words in your list. Click one of these items, and the word will appear in the document.