selectgaq.blogg.se

We will fill the Location field as D3 and check the existing worksheet box.We will click on anywhere within the table and click on Pivot table as shown in figure 7.We will click on the Insert tab and click on Tableįigure 8: Created table Inserting the Pivot Table.With the drop-down menu, we will create data that has clients and Sales.If we enter a value in the range ( A3:A11 ) that is not in I3:I5, we will receive an error messageįigure 5: Error message due to an Invalid Input in the range Setting up the Data.We will select List in the Allow Validation criteria and select the range (I3:I5) of the options for the list as the source.We will select the range where we will insert only values present in the list.We will open a new sheet and type the content that will form the main part of our tableįigure 1: Options for the Drop-down List or menu.Creating the Options for the Drop-down Menu The steps below will walk through the process. This also prevents values that we do not allow to be entered into the table. We can create a drop-down menu in preparing a pivot table to ensure that there aren’t spelling mistakes. Here is a Guide on Working with a Pivot Table Drop Down List