• Excel Book Excerpt

Excel Drag Fields to the Pivot Table

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Drag Fields to the Pivot Table

Problem: I want to go back to dragging fields around the pivot table like I did back in Excel 97-2003.

Strategy: There is a way to go back to the old style. Follow these steps:

1. Right-click any cell in the pivot table. Choose PivotTable Options.

2. Go to the Display tab within the PivotTable Options dialog.

3. Choose Classic PivotTable Layout.


Figure 884 Like Coke Classic, with less bite.

You can now drag fields to the report.


Figure 885 Drag fields from the field list to the report.

When you think about it, the four blue boxes in the old pivot table layout are really drop zones. In the current Excel, Microsoft moved the drop zones to the bottom of the pivot table field list.

Gotcha: this setting is not universal. You will have to change the setting for each pivot table.

Gotcha: if you save your file as an .xls file, you will get this style every time, but as you will read in the next topic, this is not a good strategy.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

Popular Pages

More Info