[header] How to add rows to a pivot table [title] Launch microsoft excel and open the workbook file containing your pivot table and source data. [title] Select the tab that contains the source data by clicking on it. [title] Review how the entries are organized in the source data. 
[substeps] Column labels in the source data are typically used as field labels for a pivot table. [title] Compare the source data to the existing pivot table and determine which column will be added to the pivot table as additionally displayed rows.