How to Create a Drop-Down List Using Data From Another Excel Worksheet
This allows you to enter data into a specific cell of a worksheet from a preset list of entries. Open Sheet1 and typeCookie pop in:into cell D1. In cells A1 through A4, throw in: Gingerbread, Lemon, Oatmeal Raisin, and Chocolate Chip. Format these cells however you wish. It won’t interfere with the functionality of the drop-down list. Here’s how: choose the cells you want to use for the drop-down list....