SEE: How to add a drop down list to an Excel cell (TechRepublic) This article assumes you know how to build a basic pivot table, but also provides instructions for building the example pivot table.