How to populate a list in Excel from another sheet
Here's a quick tip for creating a Microsoft Excel drop down list from another tab. 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. The good news is that identifying a list on another sheet requires only an extra click to access the sheet. We can illustrate this as follows. (You can work with your own data ordownload the demonstration .xlsx and .xls files.)
Figure A With an extra click to identify the sheet, you can easily display list items on another sheet. Get more Excel tipsRead 56 Excel tips every user should masterand the tutorials how to add a condition to a drop down list in Excel, how to add color to a drop down list in Excel,how to change an Excel conditional format on the fly, andhow to combine Excel's VLOOKUP() function with a combo box for enhanced searching. Also, check out these free PDF download compilationsBuild your Excel skills with these 10 power tipsand13 handy Excel data entry shortcuts. |