Add Rows to a Pivot Table
Pivot tables are used to group and organize the source data from a spreadsheet. The primary value of pivot tables is that they allow the organization of the data to be manipulated in a multitude of ways, depending upon the conclusions that are being drawn from the information and the needs of the spreadsheet's users. Adding rows to a pivot table offers another means by which the data can be organized and displayed. Here's how to add rows to a pivot table to provide more depth and meaning to your findings.
Contents
Steps
- Launch Microsoft Excel and open the workbook file containing your pivot table and source data.
- Select the tab that contains the source data by clicking on it.
- Review how the entries are organized in the source data.
- Column labels in the source data are typically used as field labels for a pivot table.
- Compare the source data to the existing pivot table and determine which column will be added to the pivot table as additionally displayed rows.
- Move to the tab containing the pivot table by clicking the appropriate worksheet tab.
- Force the "Pivot Table Field List" or "Pivot Table Wizard" to launch by clicking one of the cells inside the pivot table area.
- Click the column label selected, drag and drop it into the "Row Labels" section of the Pivot Table Field List.
- Reorder the field labels in the "Row Labels" section and note the changes made to the pivot table.
- Select the order for the row labels that best suits your needs.
- Revise the page layout for the spreadsheet in order to accommodate the newly added rows.
- Change the layout to either Portrait or Landscape, adjust the scaling and set it to the correct number of sheets for printing or screen display.
Tips
- Your additional field by which the pivot table data will be grouped and displayed may work better as a "Column Label." Try dragging and dropping the field label into the row and column label sections to observe how each organization affects the display of the pivot table.
Warnings
- Save a copy of the worksheet with a new name before making changes to the pivot table or source data. This way, you can always return to the original worksheet if you make a mistake.
Related Articles
- Add Data to a Pivot Table
- Add a Field to a Pivot Table
- Add a Custom Field in Pivot Table
- Change an Excel Pivot Table Source
- Calculate Difference in Pivot Table
- Create a Chart from a Pivot Table
- Add Header Row in Excel
- Navigate in Excel Without Using Scrollbars or Arrows
