![]() With an extra click to identify the sheet, you can easily display list items on another sheet. Click OK, which will return you to the new sheet, where you’ll find a populated list in E4 ( Figure A).Click the Lists sheet tab or the tab that contains your list items.When you get to the step 5, where you identify the source, click inside the Source Control.Select E4 in the new sheet and repeat the instructions for creating a drop down from a previous Excel article through step 4.(“Different sheet” in the demonstration file.) If you have only one sheet, add a new one.(You can work with your own data or download the demonstration. The good news is that identifying a list on another sheet requires only an extra click to access the sheet. ![]() The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. Image: AndreyPopov, Getty Images/iStockphoto Here's a quick tip for creating a Microsoft Excel drop down list from another tab. ![]() How to create an Excel drop down list from another tab
0 Comments
Leave a Reply. |