Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...
Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...