Click the "OK" button to create the drop-down list for the selected cell or group of cells on the worksheet, or "Sheet2." Save the workbook. Hover over a cell to reveal the drop-down list box.

You don’t need to manually re-enter Excel spreadsheet data in another workbook. Learn how to copy a worksheet to another workbook here.

This article provides step-by-step instructions for color customizing your drop-down list in Microsoft Excel.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

How to Compare Values of One Workbook to Another in Excel. In Microsoft Excel you can use a formula to compare two similar documents in different workbooks. For example, if a small business has ...