You can do this either by adding a new name in the Name Manager window ( Formulas tab > Name Manager > New) or typing the name directly in the Name Box. Now you need to create names for your main list and for each of the dependent lists. For example, I'm creating a cascading dropdown of fruit exporters and column A of my source sheet ( Fruit) includes the items of the first dropdown and 3 other columns list the items for the dependent dropdowns. Type the entries for the drop-down lists.įirst off, type the entries you want to appear in the drop-down lists, each list in a separate column.
This method works with all versions of Excel 2016, 2013, 2010 and earlier.
All you need is a few named ranges and the INDIRECT formula.
Next, select the Insert tab from the toolbar at the top of the screen. In this example, we've selected cell A1 on Sheet2. Highlight the cell where you'd like to create the pivot table. In this example, the data is found on Sheet1. To create a pivot table in Excel 2016, you will need to do the following steps:īefore we get started, we first want to show you the data for the pivot table.
If you want to follow along with this tutorial, download the example spreadsheet.ĭownload Example Steps to Create a Pivot Table