STEP 3: Do the same for the other three columns:īeverage column values – Beverage (Named Range)īreakfast column values – Breakfast (Named Range)Īfter you created all these Named Ranges, click on the Name Box dropdown and see our newly created Named Ranges: Highlight the Category values, and type in the Name Box the name Category The Name Box is on the far left of the Formula Bar. STEP 2: We are going to assign Named Ranges for all four columns. Notice that the Category column has the values Meat, Beverage, and Breakfast. STEP 1: We have our data ordered in the following columns: Category, Meat, Beverage, Breakfast. Let us go through the steps on the dependent drop down list Excel in detail:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |