How to Make a List of Excel Data Into Data Separated by Comma. Microsoft Excel 2010 stores data within cells, which are simply segregated pieces of the spreadsheet that Excel can then reference to ...

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Image: AndreyPopov, Getty Images/iStockphoto The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down.