Method 2: Name the Range . The second way to create a drop-down list from a column in a formatted table involves naming the source range. Before launching the Data Validation dialog box, select ...

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.