Tom’s Tutorials For Excel: Setting 2007+ PivotTables for Drag and Drop

Tom’s Tutorials For Excel: Setting 2007+ PivotTables for Drag and Drop

Excel’s PivotTable models changed starting with version 2007. If you miss the ability to drag and drop field items from the field list into a pivottable’s drop zones the way you could do in the good old days of versions 2003, here’s how you can adjust that setting.

This setting also provides the functionality of dragging (pivoting) fields directly on the pivottable, for example from rows to columns or from columns to rows.

Default look of a pivottable being built in version 2010.


With the Data area selected, from the Ribbon:
• Click the Options tab in the PivotTable Tools section.
• Click the PivotTable icon in the far left panel of the Ribbon.
• From the drop-down menu, click Options, then click Options again.




In the PivotTable Options dialog box:
• Click the Display tab.
• Select the option “Classic PivotTable layout (enables dragging of fields in the grid)”
• Click the OK button.


Here are the drag and drop zones.