How to create an Excel drop-down list from another tab

1641050955 How to create an Excel drop down list from another tab

Here's a quick idea for creating a Microsoft Excel drop-down list from another tab.

Image: AndreyPopov, Getty Images / iStockphoto

The data you want to use on the Excel drop-down list will usually not be in the same page as the drop-down list. The good news is that all you have to do is click on a list on another page, just click extra to get to the page. We can illustrate this as follows. (You can work with your own data or download the .xlsx and .xls display files.)

  • If you only have one page, add a new page. ("Different page" in display file.)
  • Select E4 in the new page and repeat the drop - down instructions from the previous Excel article through step 4.
  • When you reach step 5, where you have identified the source, click inside Source Control.
  • Click on the Lists page or the tab containing your list products.
  • Select the list (A1: A4).
  • Click OK, which will take you back to the new page, where you will find a population list in E4 (Figure A.).

Figure A.

createamicrosoftexceldropdownlistfrom-anothertab-figure-b.jpg

With an extra click to identify the page, you can easily display list items on another page.

Index

    Get more Excel suggestions

    Read 56 Excel tips that all users should master and the tutorials how to add a dropdown list setting in Excel, how to add color to a drop list in Excel, how to change a powerful Excel layout of the fly, and how to combine Excel's VLOOKUP () function with a combo box for advanced analysis. Also, check out these free PDF download collections Build your Excel skills with these 10 powerful tips and 13 handy Excel data entry summaries.

    READ  Pokémon Unite: A list of Pokémon that can be played

    Related Posts

    Deja una respuesta

    Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

    Subir

    We use cookies to ensure that we give the best user experience on our website. If you continue to use this site we will assume that you agree. More information